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: 
Nir
Contributor II
Contributor II

"-" instead Zero

Hi 

Sometimes in measurements I get result as Zero (which ok for me ) but also I can see the sign "-" which not so good for me but i know it is also mean Zero ?

is there a way to avoid this "-" , why i get it instead Zero? 

Thx

Labels (2)
2 Replies
justISO
Specialist
Specialist

Hi, I believe '-' (most of the time in gray background) is not a zero, but rather indicating empty value, no value. In such cases, fore example if you sum([null_value]) you'll get 0 as an answer, same as sum([zero_value]) also =0, so it looks the same, but 0 and NULL are bit different values.

You can try to 'convert' null values to zero with if(isnull([Value]),0,[Value])

Nir
Contributor II
Contributor II
Author

GREAT THX , I WILL TRY IT