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: 
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

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