topic Re: How to exclude just 1 value with set analysis? in QlikView

How to exclude just 1 value with set analysis?

robinwiman — Sat, 16 Nov 2024 04:17:59 GMT

So I'm familiar with sets like:

{$<Country = {"*"} - {'Sweden'}>}

{$<Country -= {'Sweden'}>}

But what this also means that I will get ALL other contries except Sweden, what if I have 5 countries showing, 10 possible, and now I want to make sure that Sweden is never shown. How can I exclude it, while still allowing a filter for the others?

Re: How to exclude just 1 value with set analysis?

sunny_talwar — Fri, 01 Mar 2019 13:13:43 GMT

This should do it (your second modifier)

{$<Country -= {'Sweden'}>}

Re: How to exclude just 1 value with set analysis?

robinwiman — Fri, 01 Mar 2019 13:17:50 GMT

Thank you for your response.
Still, it will then show ALL other countries but Sweden.
I don't want to reverse the selection, I just want Sweden to not show in this particular table. When I use {$<Country -= {'Sweden'}>} it will show over 40 countries I have available. With no set analysis, the table will show only 5 countries (these are the only ones I want to show, since they have a sales value).

Re: How to exclude just 1 value with set analysis?

sunny_talwar — Fri, 01 Mar 2019 13:20:48 GMT

So, {$<Country -= {'Sweden'}>} should exclude Country = Sweden with or without selection. But will also exclude Countries which are not in your current selection. Is this not what you want?

Re: How to exclude just 1 value with set analysis?

robinwiman — Fri, 01 Mar 2019 13:23:10 GMT

This is my expression:
Sum ( {<[Store Type2] = {'Concept','SiS','Soft shop'} >} {$<Country -= {'Sweden'}>} If(WildMatch(SeasonCalc, vCurrentSeasonCalc),Fsgantal*Shoes))

Re: How to exclude just 1 value with set analysis?

sunny_talwar — Fri, 01 Mar 2019 13:25:15 GMT

You might need to combine the two modifiers into one

Sum({<[Store Type2] = {'Concept', 'SiS', 'Soft shop'}, Country -= {'Sweden'}>} If(WildMatch(SeasonCalc, vCurrentSeasonCalc), Fsgantal*Shoes))

Re: How to exclude just 1 value with set analysis?

marcus_sommer — Fri, 01 Mar 2019 13:25:26 GMT

Try it with:

{$<Country *= {"*"} - {'Sweden'}>}
or maybe
{$<Country = p({< Country -= {'Sweden'}>} Country)>}

- Marcus

Re: How to exclude just 1 value with set analysis?

robinwiman — Fri, 01 Mar 2019 13:33:12 GMT

Thanks. I was missing to put them both in the same set. This works.