topic Re: Set1 - Set2 in QlikView

Set1 - Set2

QSense — Thu, 03 Oct 2013 13:08:37 GMT

Hello everyone ,

I have 3 sets They includes mutual values in both sets

I want to count values for each set at belong only that sets

For example

a--> 1,2,3

b--> 2,5

c--> 1,6,7

I want distinct values belong to only that sets

count(a) = one value (3)

count(b) = one value (5)

count (c)= two values (6,7)

Anonymous — Thu, 03 Oct 2013 13:16:31 GMT

what do you mean by Set.. is this a field...

can you upload a sample QVW

srchilukoori — Thu, 03 Oct 2013 13:19:39 GMT

=Count(Distinct {<Field = {'a'}>} Values)

Replace the "Field" in the above expression with the field that distinguishes the values as a, b, c.

CELAMBARASAN — Thu, 03 Oct 2013 13:27:08 GMT

Something like

1. =Count({<A-=P(B)> * <A-=P(C)>} DISTINCT A)

2. =Count({<B-=P(A)> * <B-=P(C)>} DISTINCT B)

3. =Count({<C-=P(A)> * <C-=P(B)>} DISTINCT C)

Thu, 03 Oct 2013 13:27:35 GMT

Hi,

I would do sth like

count ({set} disctinct values)

where the set will be {set 1} - {set 2} to exclude the values of set 2 that could be in set 1

and where

set 1= {<Field = {'A'}>}

set 2 = {<Field = - {'A'}>} (= and - signs : everything except A)

If you want the current selection except A, inverse the = and - signs to do : set 2 = {<Field -= {'A'}>}

Fabrice