Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Hi,
you can implement set analysis exclusion see below HIC post:
thanks
Vikas
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
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)