Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
gaurab
Contributor
Contributor

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

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.

Labels (1)
1 Reply
Or
MVP
MVP

Have a look at the solutions proposed here:

https://community.qlik.com/t5/QlikView-App-Dev/Set-Analysis-Avoiding-all-selections-except-one/td-p/...

tl;dr version - something along the lines of:

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