topic Re: AND in Set Analysis in QlikView

AND in Set Analysis

tahirkhalil — Sat, 16 Nov 2024 05:09:57 GMT

HI All,

How can I implement AND within SET.

I have an example - one ticket contain multiple activities and have responses against each.

For me a valid ticket is only one which have Activity A3 and A4 both with response 1.

I know if I use =count(DISTINCT {<Activity={"A3","A4"}, Response={1}>} Ticket) - it is working as OR. I want to use condition:

(Activity = A3 AND Activity = A4) AND Response=1

How to achieve that through set analysis? See attached document.

Regards,

Tahir

Re: AND in Set Analysis

Thiago_Justen_ — Thu, 22 Nov 2018 09:13:13 GMT

Your set is ok. Try it without the distinct...I guess you have the same ticket for both activities and response. Then you got only 1 as result because of the distinct.

Re: AND in Set Analysis

tresB — Thu, 22 Nov 2018 09:26:53 GMT

Try like:

=count(DISTINCT {<Ticket=p({<Activity={'A3'}, Response={1}>})
*
p({<Activity={'A4'}, Response={1}>})>} Ticket)

Re: AND in Set Analysis

tahirkhalil — Thu, 22 Nov 2018 09:32:46 GMT

No the set is wrong - in fact it is working as OR I want this to be done as AND

Re: AND in Set Analysis

robert99 — Thu, 22 Nov 2018 09:43:21 GMT

I haven't a clue what you are trying to achieve to be honest

But would this work

count(DISTINCT {<Activity={"A3","A4"}>} Ticket)

count(DISTINCT {<Response={1}>} Ticket)