Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rittermd
Honored Contributor

Straight Table not affected by any filter choices?

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.

5 Replies
jsf_fasoli
Contributor II

Re: Straight Table not affected by any filter choices?

This post shows how to make a "detached" objetc manually. Hope it helps!

Detach object in Qlik Sense | Qlik Community

rittermd
Honored Contributor

Re: Straight Table not affected by any filter choices?

How exactly would that work if you had 9 dimensions?

OmarBenSalem
Esteemed Contributor

Re: Straight Table not affected by any filter choices?

if u have dim and measures, and ad the {1} in ur measures, even the dims will be frozen.

OmarBenSalem
Esteemed Contributor

Re: Straight Table not affected by any filter choices?

there is no native alternate state in qlik sense; he would've to create island tables to do that..

OmarBenSalem
Esteemed Contributor

Re: Straight Table not affected by any filter choices?

a way to use alternate states in QS:

Comparative Analysis - Alternate States with Qlik Sense

Community Browser