Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to show a KPI that is not modified based on the dashboard selections (use the {1} operator)
I tried putting the 1 at every location I could but still did not work.
Here is my KPI's formula:
sum({1<[Date.autoCalendar.Year]={2019}>}Aggr({1}sum({1}[Order Qty]) * ContractPrice, [Date.autoCalendar.Date], Retailer, Model))
The KPI works fine but if I drill down on a month the KPI gets updated which I don't want. I want it fixed to 2019
Thanks for the help
My best guess is that the issue lies within the Contract Price.
=sum({1< [Date.autoCalendar.Year]={2019}>} Aggr({1}sum({1}[Order Qty]) * ContractPrice, [Date.autoCalendar.Date], Retailer, Model))
You will need to handle the ContractPrice within a kind off basic aggregation function, by not using one Qlik Sense will treat it as an Only(ContractPrice). In you case assume that the most likely alternatives would be one of the two following suggestions.
=sum({1< [Date.autoCalendar.Year]={2019}>} Aggr({1}sum({1}[Order Qty] * ContractPrice), [Date.autoCalendar.Date], Retailer, Model))
=sum({1< [Date.autoCalendar.Year]={2019}>} Aggr({1}sum({1}[Order Qty] ) * sum({1}ContractPrice), [Date.autoCalendar.Date], Retailer, Model))
My best guess is that the issue lies within the Contract Price.
=sum({1< [Date.autoCalendar.Year]={2019}>} Aggr({1}sum({1}[Order Qty]) * ContractPrice, [Date.autoCalendar.Date], Retailer, Model))
You will need to handle the ContractPrice within a kind off basic aggregation function, by not using one Qlik Sense will treat it as an Only(ContractPrice). In you case assume that the most likely alternatives would be one of the two following suggestions.
=sum({1< [Date.autoCalendar.Year]={2019}>} Aggr({1}sum({1}[Order Qty] * ContractPrice), [Date.autoCalendar.Date], Retailer, Model))
=sum({1< [Date.autoCalendar.Year]={2019}>} Aggr({1}sum({1}[Order Qty] ) * sum({1}ContractPrice), [Date.autoCalendar.Date], Retailer, Model))