Can we force Qlikview to show SUM(Null values) as NULL(i.e '-) rather than zero?

[Karthik3]

I have seen some discussions over here and know some workarounds but can we set at global level for qlikview to show sum(null values) as null rather than zero?

Thanks.

[sunny_talwar]

Sure, may be like this:

If(Sum(Sales) > 0, Sum(Sales))

When Sum(Sales) = 0, it will give you Null, instead of 0

[Karthik3]

Thanks sunny. I know this workarounds and IF slows performance. IS there any setting at global level to make qlikview show sum(null values) as null?

[sunny_talwar]

AFAIK there is no global settings to do this, but I may be wrong

[Chanty4u]

Adding to Sunny.

if(sum(sales)>0,'-','-')