topic Set Analysis to count when not have a value in QlikView

Set Analysis to count when not have a value

Wed, 14 Mar 2012 17:44:22 GMT

I need to count how many Users do not have Category = C.

With the next example, the answer is 1 (User 2)

I used:

count({<Category -= {'C'}>} distinct User)

but the result is: User 1 = 1 and User 2 = 1

Thanks in advance

deepakk — Wed, 14 Mar 2012 18:00:03 GMT

hi,

Try the attach application

Deepak

Wed, 14 Mar 2012 19:36:55 GMT

Hi Deepak, so i get the users that have Category = C (User 1) and need the opposite (User 2)

Addapting your code I did i little change and now it do the correct but maybe there is other better solution.

The syntax i used was:

Count (DISTINCT {<Category-={"C"}>}User)-Count (DISTINCT {<Category={"C"}>}User)

Thanks for your help

deepakk — Wed, 14 Mar 2012 20:29:23 GMT

hi,

Yes you can do it in below way.

Count (DISTINCT {<Category =Category-{"C"}>}User)

Deepak

Fri, 16 Mar 2012 05:54:22 GMT

That way it doesn't work.

I attach file