Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to disable filtering for certain objects in QlikSense?
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.
Hi Duston,
Use Expression in Filter Field Value,
If(wildmatch([Field values],'A','B','C'),'Ignore','Consider')
Thanks,
Arvind Patil
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