Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

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
mov
Esteemed Contributor III

Re: How to exclude value from field in expression Count

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

2 Replies
mov
Esteemed Contributor III

Re: How to exclude value from field in expression Count

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

MVP
MVP

Re: How to exclude value from field in expression Count

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

Community Browser