Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
danialier
Creator III
Creator III

Exclude a value from a formula

Hello,

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

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

Thanks,

dani

1 Solution

Accepted Solutions
crusader_
Partner
Partner

Hi,

Try this:

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

Hope this helps.

Andrei

View solution in original post

2 Replies
crusader_
Partner
Partner

Hi,

Try this:

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

Hope this helps.

Andrei

View solution in original post

PrashantSangle

Hi,

Which field gives you N/A

Try this,

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

or

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.