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

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

Karthik3 — Wed, 25 Nov 2020 16:16:04 GMT

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.

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

sunny_talwar — Wed, 24 Aug 2016 11:22:04 GMT

Sure, may be like this:

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

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

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

Karthik3 — Wed, 24 Aug 2016 11:25:35 GMT

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?

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

sunny_talwar — Wed, 24 Aug 2016 11:29:31 GMT

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

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

Chanty4u — Wed, 24 Aug 2016 11:30:21 GMT

Adding to Sunny.

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