topic Ignore one selection in Set Analysis in QlikView

Ignore one selection in Set Analysis

Tuzlukov — Sat, 16 Nov 2024 02:23:37 GMT

Hi!

I have this set analysis in my expression:

Count({<[Contact IsActive] = {'true'}, [Contact SpecialtyName] = {'n1','n2'}>} DISTINCT [Contact Id])

I want to keep [Contact SpecialtyName] filter, but i want to ignore only [Contact IsActive] filter. Is it possible to do in one set analysis?

If i write '1' before set analysis, it (of course) ignore both of filters. How to keep just one of them?

Count({1<[Contact IsActive] = {'true'}, [Contact SpecialtyName] = {'n1','n2'}>} DISTINCT [Contact Id])

Re: Ignore one selection in Set Analysis

AdiPai — Wed, 25 Sep 2019 14:02:47 GMT

What about writing -

Count({<[Contact IsActive] = {'false'}, [Contact SpecialtyName] = {'n1','n2'}>} DISTINCT [Contact Id])

Re: Ignore one selection in Set Analysis

Gysbert_Wassenaar — Wed, 25 Sep 2019 14:11:58 GMT

Your expression as it is now will also ignore user selections in those two fields. It uses fixed selections. Adding a 1 before the set modifiers will not change that. That will simply make it ignore user selections in every field.

If you want to ignore user selections in a field and don't want to replace it with a fixed selection then use something like

Count({<[Contact IsActive] =, [Contact SpecialtyName] = {'n1','n2'}>} DISTINCT [Contact Id])

That will use all possible values in Contact IsActive regardless of user selections in that field.

If you want to keep the user selections then simply remove the set modifier for that field from the expression:

Count({< [Contact SpecialtyName] = {'n1','n2'}>} DISTINCT [Contact Id])

Re: Ignore one selection in Set Analysis

Tuzlukov — Thu, 26 Sep 2019 06:31:39 GMT

Ok, maybe i asked wrong question.

Please see picture below. I have expression "base" calculated by code from my first message.

And i also have dimension "week" which unable to compare with table that contains "base" data. I want to get in all fields "base" with category "A" value 54. Independently to "week":

there is something wrong with photo attachment

Without week dimension my table looks like this:

one more photo

Hope you understand me 🙂

Re: Ignore one selection in Set Analysis

Brett_Bleess — Thu, 03 Oct 2019 21:37:21 GMT

Andrey, check out the following Design Blog post, and there are some other links inside the post as well, be sure to check those too, as I think you may actually need one of the other ones to do what you want, but I hope this may be what you need to help you get things figured out.

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Regards,
Brett