topic Re: Set Analysis - AND operator on one dimension in QlikView

Set Analysis - AND operator on one dimension

josephinetedesc — Sat, 16 Jan 2016 12:13:06 GMT

Hi All

The rows of information are shown below:

What I would like to know is how do I get the number of Persons who have Activity A and Activity B.

There should only be 5 persons but I do not!

=Count({<Activity = e({<Activity = {'A','B'}>})>} DISTINCT Person)

this gives me 10

Thank you

swuehl — Sat, 16 Jan 2016 12:16:11 GMT

Try

=Count({<Person = p({<Activity = {'A'}>}) *p({<Activity = {'B'}>}) >} DISTINCT Person)

Gysbert_Wassenaar — Sat, 16 Jan 2016 12:16:29 GMT

Count({<Person=P({<Activity={'B'}>}Person),Activity={'A'}>}DISTINCT Person)

josephinetedesc — Sat, 16 Jan 2016 12:31:23 GMT

this works

josephinetedesc — Sat, 16 Jan 2016 12:37:52 GMT

this works too

josephinetedesc — Sat, 16 Jan 2016 12:39:32 GMT

Thank you both very much I will now look at the p and I have read about the * for intesection.

maxgro — Sat, 16 Jan 2016 12:56:21 GMT

=Count({<Person={"=count({$ <Activity={A,B}>} distinct Activity)=2"}>} DISTINCT Person)