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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

Null symbol

Hello got a pivot table (check image below)
the work-group IAG-Support doesn't have data for Feb, Mar, and April 2019
is there a way to remove the '-' for null and make the cell blank?

in May for the Planned Man-Days I got Zero and I manage to change the text color to white when zero but not when null

evi.PNG

I can walk on water when it freezes
3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Add +sum({1}0) to your measures

talk is cheap, supply exceeds demand
ali_hijazi
Partner - Master II
Partner - Master II
Author

didn't work
I can walk on water when it freezes
W4ld
Contributor II
Contributor II

Maybe use a rangesum or another rangefunction on your measure