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: 
Giansonn
Creator
Creator

How can I ignore filter for a specific value in set analysis?

I am currently using set analysis to ignore filters like this:

 

count({<marketplace=>} ID)

 

What I would like to do is to always include 'Not Sold' in any selection, like this:

 

count({<marketplace='Not Sold'>} ID)

 

I would like to have this on top of any filters selected.

How can I do this to make sure that 'Not Sold' is never filtered?

Labels (4)
1 Solution

Accepted Solutions
Or
MVP
MVP

+= will help!

Count({< marketplace += {'Not Sold'} >} ID)

 

View solution in original post

4 Replies
Or
MVP
MVP

+= will help!

Count({< marketplace += {'Not Sold'} >} ID)

 

Giansonn
Creator
Creator
Author

Thanks Or, I didnt know about this inclusion restriction!

Or
MVP
MVP

Glad to help.

Qlik's help page on set analysis and set expressions is actually pretty handy - I recommend checking it out.

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

 

Giansonn
Creator
Creator
Author

Sorry I have already accepted your answer but actually this is the way to do it:

 

count({+1<marketplace={'Not Sold'}>} ID)

 

and if I have other set expressions in place:

 

count({$<sale_day=> $<marketplace+={'Not Sold'}>} ID)

 

For some reason if I do not separate these two expressions my data changes.