Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
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]))