Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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
Master II
Master II

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