How To Disable Filter

[dustonmoore]

Is there a way to disable filtering for certain objects in QlikSense?

[rwunderlich]

The technique is called Set Analysis.  Set Analysis allows you to ignore or modify selections within an expression.

Sum({1}Sales)   // Ignores all selections

Sum({<Year=>}Sales)  // Ignores any selection in field Year.

You can learn more about Set Analysis in the help and here in the Community site.

[arvind_patil]

Hi Duston,

Use Expression in Filter Field Value,

If(wildmatch([Field values],'A','B','C'),'Ignore','Consider')

Thanks,

Arvind Patil

[JohnOM]

Hi Rob

Any advice on getting this to work on a Qlik Sense mini chart sparkline?

Both {1}  and {<MonthYear=>} seem to get ignored on MonthYear selection and so return a dot for the MonthYear selected

Ideally, I would like previous 6 months trend to continue showing based on month year selection

A workaround was to have calendar island then add set analysis in the table calcs instead, but this means every calc has to have that, which is messy.

cheers

John