topic Re: set analysis not equal in QlikView

set analysis not equal

richard_chilvers — Thu, 17 Dec 2015 14:43:15 GMT

There are a number of discussion on this forum about this topic. I have tried to follow these to do a COUNT based on all values where the field called OBAC_Status is not equal to 'Duplicates'.

It works fine if I use

count( distinct Telephone) - count({ <OBAC_Status={'Duplicates'}>} distinct Telephone)

but not:

count({ <OBAC_Status={'*'}-{'Duplicates'}>} distinct Telephone)

What is the difference please ?

Re: set analysis not equal

sunny_talwar — Thu, 17 Dec 2015 14:44:32 GMT

I think the first expression is including any blank OBAC_STATUS, where as the second one is excluding blank and Duplicates

Re: set analysis not equal

sunny_talwar — Thu, 17 Dec 2015 14:49:12 GMT

Have a look at the attached sample to get a better understanding.

Re: set analysis not equal

richard_chilvers — Thu, 17 Dec 2015 14:59:17 GMT

Thanks - but I don't think this is the answer. There should be no blanks. If there are, the number will be small, but the difference in the 2 different expressions is large.

Re: set analysis not equal

sunny_talwar — Thu, 17 Dec 2015 15:01:38 GMT

Okay. Can you share a sample? It is hard to say what it could be, without seeing what you have.

Re: set analysis not equal

swuehl — Thu, 17 Dec 2015 15:10:13 GMT

If the same telephone number could have several status, e.g

+00 12345678 Duplicates

+00 12345678 Main

your two expressions are fundamental different.

First one will return zero for above sample, second will return 1.

Re: set analysis not equal

richard_chilvers — Thu, 17 Dec 2015 15:17:10 GMT

Yes - that is very possible. I will explore and see whether I can better understand my data and what the 2 solutions do !

Thanks

Re: set analysis not equal

effinty2112 — Thu, 17 Dec 2015 16:01:14 GMT

Hi Richard,

count({ <OBAC_Status={'*'}-{'Duplicates'}>} distinct Telephone)

will count distinct Telephone disregarding any selections made in the field OBAC_Status except where equal to 'Duplicates'.

This can be written more simply as

count({ <OBAC_Status=-{'Duplicates'}>} distinct Telephone)

compare with

count({ <OBAC_Status-={'Duplicates'}>} distinct Telephone)

will count distinct Telephone in the currently selected records except where equal to 'Duplicates'.