Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
+= will help!
Count({< marketplace += {'Not Sold'} >} ID)
Thanks Or, I didnt know about this inclusion restriction!
Glad to help.
Qlik's help page on set analysis and set expressions is actually pretty handy - I recommend checking it out.
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.