Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table with several columns. Some are just dimensions and a couple are measures.
I want this table to be frozen and not recalculate when any filters are picked.
I don't quite see how to do that if it is even possible. I know how to do it in Set Analysis. But I don't have expressions in every column.
This post shows how to make a "detached" objetc manually. Hope it helps!
How exactly would that work if you had 9 dimensions?
if u have dim and measures, and ad the {1} in ur measures, even the dims will be frozen.
there is no native alternate state in qlik sense; he would've to create island tables to do that..
a way to use alternate states in QS: