Set analysis AND

Wed, 13 Jul 2011 13:02:16 GMT

Hi Everyone,

I have two list boxes, business1 & business2. I want a count of whether you are in business1, business2 or both.

I have the first two set up as follows:

count( {<business2=>} distinct ID) // gives me a count of those selected in business1 irrespective of what is selected in business2

count( {<business=>} distinct ID) //gives me the opposite count to above

Is it possible to use set analysis to give me the count of ID's who are in BOTH groups? In essence this gives me the figures one would see in a venn diagram.

Thanks

Gareth

Re: Set analysis AND

martin59 — Wed, 13 Jul 2011 13:37:09 GMT

Hi,

I think you have to do this

count({<Business1=P(Business2)>} distinct ID)

Hope that helps you !

topic Re: Set analysis AND in QlikView

Set analysis AND

Re: Set analysis AND