topic Re: minus fields in QlikView

minus fields

QSense — Thu, 03 Oct 2013 10:53:45 GMT

Hello everyone ,

I have 3 sets They includes mutual values in both sets

I want to count values for each set at 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)

tresB — Thu, 03 Oct 2013 11:27:26 GMT

Say your field name is DataField(With values 1,2,3,4,5,6,7). Now,

Count(a) Expression: =Count({<DataField={1,2,3}>} Distinct DataField)

Count(b) Expression: =Count({<DataField={2,5}>} Distinct DataField)

Count(c) Expression: =Count({<DataField={1,6,7}>} Distinct DataField)