operators - select all

[dominic_marchan]

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

[Vegar · Accepted solution]

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))