topic Re: Exclude a value from a formula in QlikView

Exclude a value from a formula

danialier — Tue, 23 Sep 2014 14:49:09 GMT

Hello,

I want te following formula to exclude the value "n/a". What should I put ?

=count({<Id>}DISTINCT(Id))

Thanks,

dani

crusader_ — Tue, 23 Sep 2014 15:00:33 GMT

Hi,

Try this:

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

Hope this helps.

Andrei

PrashantSangle — Tue, 23 Sep 2014 15:03:54 GMT

Hi,

Which field gives you N/A

Try this,

Count({<Id-={'n/a'}>}Distinct Id)

count(if(not wildmatch(Id,'n/a'),Distinct ID))

Regards