topic Re: How can I ignore filter for a specific value in set analysis? in QlikView

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

Giansonn — Sat, 16 Nov 2024 18:32:16 GMT

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?

Or — Thu, 04 Jun 2020 09:52:48 GMT

+= will help!

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

Giansonn — Thu, 04 Jun 2020 10:05:08 GMT

Thanks Or, I didnt know about this inclusion restriction!

Or — Thu, 04 Jun 2020 10:24:04 GMT

Glad to help.

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

Giansonn — Thu, 04 Jun 2020 11:49:20 GMT

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.