Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to exclude value from field in expression Count

Hello,


In a chart expression how can I exclude the value 'n/a' from the report field when doing a count? I only want to count values that are not 'N/A' for Report.

Count(report)

Thank you!

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

This should work:
=count({<report-={'N/A'}>} report)

View solution in original post

2 Replies
Anonymous
Not applicable
Author

This should work:
=count({<report-={'N/A'}>} report)

maxgro
MVP
MVP

count({$ <Report-={N/A}>} Report)