topic Re: Set analysis intersection in QlikView

Set analysis intersection

jvitantonio — Mon, 10 Sep 2012 14:33:51 GMT

Hi everyone. I've been trying different formulas to achieve what I want but didn't succeed.

It's very simple. I have a list of codes and exams.

code	exam
A	1
A	2
A	3
B	1
C	2
D	5

Now, I need to count only those codes that have in exam at least values 1 AND 2. The outcome in this case should be 1 because code A is the only code containing 1 AND 2 among its exams.

Any thoughts?

Thanks!

Re: Set analysis intersection

mutuverria — Mon, 10 Sep 2012 15:16:25 GMT

Hi! Try it

Aggr(Count( {$<exam = {1,2}>} code), exam)

Re: Set analysis intersection

Mon, 10 Sep 2012 15:49:13 GMT

Hello,

try

sum( {<code = P ({<exam={"1"}>} code ) >*<code = P ({<exam={"2"}>} code ) > } exam )

Re: Set analysis intersection

jvitantonio — Tue, 11 Sep 2012 07:00:41 GMT

Thank you guys for your valuable time. Unfortunatly non of your solutions work. I need to show the result (in this case is 1) in a text object so I make sure the solution works.

Any other ideas?

Re: Set analysis intersection

Tue, 11 Sep 2012 07:05:26 GMT

i think you could have tried a bit more with the exemple i sent to you:

=count (distinct {<code = P ({<exam={"1"}>} code ) >*<code = P ({<exam={"2"}>} code ) > } code )

Re: Set analysis intersection

jvitantonio — Tue, 11 Sep 2012 07:13:31 GMT

Thank you baptiste! It works now

Re: Set analysis intersection

mukesh19 — Tue, 19 Sep 2017 10:52:40 GMT

Hi MARCHAND,

I to have the same problem but I need code rather than the count in the above expression. Can u please help me in achieving it.

Thanks in Advance,

Mukesh