topic Set Analysis question - empty result set in QlikView

Set Analysis question - empty result set

theresaa — Thu, 04 Jun 2015 18:12:59 GMT

Example Data:

If I want to display the count of Units with a status of 'OK' in a text box, I use:

=count(distinct {<Status = {'OK'}>}UnitNumber) and the result in the text box is 3

and it works fine.

But - if the user were to click on the word 'Bad' in the above table box, the result in the text box remains at 3, when it should be 0.

If the user were to click on the UnitNumber of 00003, it calculates correctly at 0

Re: Set Analysis question - empty result set

sunny_talwar — Thu, 04 Jun 2015 18:37:58 GMT

Try this expression instead of the one you have.

=Count(DISTINCT {<Status -= {'Bad'}>} UnitNumber)

Re: Set Analysis question - empty result set

maxgro — Thu, 04 Jun 2015 18:48:55 GMT

maybe

count(distinct {<Status = {'OK'}>*<Status =P(Status)>}UnitNumber)

Re: Set Analysis question - empty result set

theresaa — Thu, 04 Jun 2015 18:49:23 GMT

Is the -= meaning NOT EQUAL? It is working this way.

Re: Set Analysis question - empty result set

theresaa — Thu, 04 Jun 2015 18:52:25 GMT

Thank You. This solution works as well. The 'P' suggests it looks for all possible values of Status?

Re: Set Analysis question - empty result set

sunny_talwar — Thu, 04 Jun 2015 18:52:55 GMT

'-=' means count everywhere in your current selection where Status is not 'Bad'

HTH

Best,

Sunny

Re: Set Analysis question - empty result set

maxgro — Thu, 04 Jun 2015 18:58:49 GMT

P possible, * intersection

more detail in the QlikView help or

Set Analysis: syntaxes, examples‌

Re: Set Analysis question - empty result set

theresaa — Thu, 04 Jun 2015 19:02:51 GMT

Thank You. I will use your solution, because it is possible in our live data that there could be more than 2 status values, and your solution will also work in that situation.

Thanks very much again.