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, the option using set analysis would be adding {1}, which means "use all the data (ignoring all selections)"
This has to be added in each expression of the table, if you have an expression like "Sum(Value)" change it to "Sum({1} Value)"
you can use below approaches ...
Sum({1} Value) -- 1 identifier -Represents the full set of all the records in the application, irrespective of any selections made.
or
Sum(<Year=,State=> Value) -- by pass possible selected dims
or use Alternate state in set analysis
sum({state1<country={'abc'}>}Value)