Need only one specific filter to be applied on the... - Qlik Community

gaurab · ‎2021-11-25

say I have a sales data set where there are many fields .

In the Application there are different filters added-

1>year

2>month

3>Country

4>region

5>currency etc.

I want to make a KPI say sum(sales),

which will disregard all the selections in the filters, only 'Country' filter will change the sum(sales) value.

Or · ‎2021-11-25

Have a look at the solutions proposed here:

tl;dr version - something along the lines of:

Expression formula: Sum({1<Country=$::Country>}[sales])

Need only one specific filter to be applied on the data set