topic Re: =count(DISTINCT(Id)) in QlikView

=count(DISTINCT(Id))

danialier — Tue, 29 Jul 2014 08:51:58 GMT

Hello,

I want to create a count formula that counts all IDs excpet the ones with " n/a ". So far I'm using

=count(DISTINCT(Id))

What else do I need to add so this fiormula is not counting the rows with " n/a " ?

Thanks,

dani

Tue, 29 Jul 2014 08:54:09 GMT

Use set analysis to remove out the n/a

=count({<Id-={'n/a'}>}DISTINCT(Id))

hope that helps

Joe

tobias_klett — Tue, 29 Jul 2014 08:55:30 GMT

Hello Dani,

do you have the 'n/a' in the Id field? Than it is:

=count({<Id=Id-{'n/a'}>} distinct Id)

Hope ths helps

Tobias

danialier — Tue, 29 Jul 2014 08:55:43 GMT

excellent, thanks Joe

Tue, 29 Jul 2014 08:58:18 GMT

Hi Dani,

use below expression:

=Count({<Id={"*"}-{'n/a'}>}DISTINCT(Id))

Thanks

Sabal

Tue, 29 Jul 2014 09:01:51 GMT

No worries, it is probably a good idea to have a look at these links for a more in depth overview of set analysis

hope that helps

Joe