Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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]))