Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Date Parts Produced
Feb 50
Feb 100
March 100
March 200
I have a table just like above. Can someone please tell me what formula I need to put on KPI measure field to just get month of Feb? It should display 150. The formula I had used previously did not work in this table, but previously my table had 3/3/24 date format. I had used Sum({<Date={"=Month(Date)=3"}>}[Parts Produced])
This formula did not work for above table. Please help! Thank you.
Hey all, i am trying to use the following api for qlik cloud along with the documentation URL:
curl "https://your-tenant.us.qlikcloud.com/api/v1/apps/{appId}" \
-H "Authorization: Bearer <API-key>"
https://qlik.dev/apis/rest/apps/#%23%2Fentries%2Fv1%2Fapps%2F-appId-get
i am using this REST API in Angular 16 (Typescript) however i keep getting an '401 Unauthorized' error. here is my code:
export class ApiService {
constructor(private http: HttpClient) {}
getApp() {
const appId = '<MY-APP-ID>';
const apiUrl = `https://<MY-Company-Tenant.us.qlikcloud.com/api/v1/apps/${appId}`;
const apiKey =
'Bearer <MY-API-KEY>';
const headers = {
authorization: apiKey,
};
return this.http.get<any>(apiUrl, { headers: headers });
}
}
here is a couple screenshots of my test app so far along with the error i am getting:
Now i know this 401 error means the API key isnt being applied or is wrong however i am testing this in another app and the API call works:
Does anyone know why this isnt working?
Hello All,
I am stumped. I need to get the max year value (by program) of cumulative field from a table we have limited to current year and beyond.
Here is the table displayed currently:
The formula for the last column is correct. I now need to only display the rows with the red highlight (the max year for each program). The problem is different programs end on different years, so we want the calculated value for the max(BC_Year) for that program and display only that row.
I have tried many combinations of max(aggr...) but I can't seem to get it right.
Can someone help me out?
Here is my cumulative formula (the last column highlighted in green):
RangeSum(Above(
(Sum ( {<Version_PROG = {'Profit & Loss'}
,VersionName_PROG={'FCF'}
>} ValueGroupCurrency_PROG ))
*
(1/(Pow(1+(
Avg(distinct{$<Version_PROG= {'Financials'}
,VersionName_PROG= {'WaCC'}
>}total Quantity_PROG) ),RowNo(total)-1)))
,0,RowNo()))
As always....thank you in advance!!!
Hi everyone,
I wrote this code to load different sales files by month:
FOR i = 1 to 12
// Generate file name based on month
LET vMonth = Pick(i,
'january', 'february', 'march', 'april', 'may', 'june',
'july', 'august', 'september', 'october', 'november', 'december'
);
trace $(i);
trace $(vMonth);
// File path
LET vFile = 'lib://MyData/sales_' & vMonth & '.csv';
trace $(vFile);
// Load data from file
Sales:
LOAD
Date,
Product,
Amount,
Price
FROM [$(vFile)]
(txt, utf8, embedded labels, delimiter is ';', msq);
NEXT i
If I only have 2 files (e.g "sales_january.csv" and "sales_february.csv") in MyData directory, I get a "Cannot open file 'lib://MyData/sales_march.csv' error.
How can I load only existing files without getting this error?
Thanks in advance for your help,
Jose
Hello
I'm trying to retrieve in my app the user name of the current user.
The OSUser() function only returns the userdirectory and the userid.
Is there a way to retrieve the user name as shown in the QMC (or when logged on the hub - at the top left)
thanks for your help
ps: we're working with Qlk enterprise Sept. 2019 Patch 1
I have daily office visit data and a weekly census for that location. How would I do the following? I'm thinking I need to use a Total function but it doesn't seem to work.
Visits Syntax:
Count({<Year={$(yearselect)},Source-={'PSHR'},[Location Description]-={'Work From Home'},[Pay Status]={'Active'},Visit_Swipe={0}>} distinct [Employee ID])
Assigned Seats Measure Syntax:
Count( {<Year={$(yearselect)},Source={'PSHR'},[Location Description]-={'Work From Home'},[Pay Status]={'Active'}>} distinct [Employee ID])
Attached some sample data for reference.
Do we have any statement from Qlik that attests to their cloud systems being patched for the below issue?
https://www.cybersecuritydive.com/news/cactus-ransomware-qlik-sense-cves/714578/
Hey folks.
I have a situation where I need to join a bunch of similar, but not identical, report files into a single.QVD. I've been renaming headers with python before loading but now my boss wants me to get rid of the python step and do it all in Qlik.
The issue is that it's a bunch of .CSV files with slightly different header names. For example "Customer #" vs "Customer number" vs "Client No." There's no option to get these to come in harmonized because they're from different vendors.
I was trying to do something like: Load Distinct If(exists('Customer #'), 'Customer #') as CustomerNumber If(exists('Client No.'), 'Client No.') as CustomerNumber
But I get an error about the headers not being unique even though I'd expect the If() to return nothing when the Exists() condition fails.
Moving the "as CustomerNumber" inside the If() statement is a syntax error.
Is there a way to do this without making temporary tables and conctenating? I'm now doing it this way and it's working but it seems inelegant and like it's more steps than should be needed.
Thanks!
I am trying to create sales info for a customizable "Current Period" and "Prior Period" setup similar to what is in our company's ERP.
I used the same field INVOICE_DATE.autocalendar.YearMonth and created two filters with alternate states for each period.
While that does work on the surface, it feels really limiting because I cannot seem to filter down any dimension field. I am using a pivot table format, and I cannot seem to filter down to one specific customer or product family or sales rep or anything.
Is there a way around this, or is this just inherent to Alt States in QLIK?
THX!
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!