I don’t want my table to filter

[jonita2]

I have only been using QlikSense for a week so please bear with me. I have a table containing one dimension (Location) and 5 measures, which are all calculated measures representing various KPIs. I have a filter pane that allows the user to see just their metrics in 1 gauge chart and 4 KPI charts. I do not want the table to filter, I want it to display all locations no matter what.

I have read documentation and numerous community posts, so I’ve seen people talk about alternate states and set analysis. But applying an alternate state did nothing, and I don’t understand how to apply set analysis here. Surely there is a simple solution for this? Any help is appreciated!!

[vikasmahajan]

Hi,

you can implement set analysis exclusion  see below HIC post:

https://community.qlik.com/t5/Design/Excluding-values-in-Set-Analysis/ba-p/1471704#:~:text=The%20ans...

thanks

Vikas

[Gabbar]

lets say you have 5 measure;
all of them are in format :-
Sum({<(Filter)>}Value)

Change the format to  :-
Sum({1<(Filter)>}Value)
in all the measures

[Ravi_Nagmal]

@jonita2 

Add set analysis {1} in you measures this will restrict you data and filters

Example : sum({1} if(match(Region,'Japan'),Totalfees)) or sum({1} Totalfees)