Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
DMG
Contributor III
Contributor III

Displaying measure result as null rather than 0 if count is 0

Hi, i have the following formula in a measure, 

=Count({<FIELD={'text_match'}>}[FIELD])

Where the result is > 0 i would like the result to appear, but if the result is 0 i would like null to appear in the cell rather than 0, is that possible ?

1 Reply
Dalton_Ruer
Support
Support

If(Count({<FIELD={'text_match'}>}[FIELD])= 0, Null(), Count({<FIELD={'text_match'}>}[FIELD]))