Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dustonmoore
Contributor II
Contributor II

How To Disable Filter

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

3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Partner - Specialist III
Partner - Specialist III

Hi Duston,

Use Expression in Filter Field Value,

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

Thanks,

Arvind Patil

JohnOM
Contributor
Contributor

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