topic Re: Sum of Null equals zero - How To Resolve in QlikView

Sum of Null equals zero - How To Resolve

nsm1234567 — Tue, 31 Oct 2017 07:59:29 GMT

Hey there,

I'm working on what should be a straightforward calculation, but I seem to be battling to get the behaviour I want. If you look at the below, I'm doing a simple sum(NumberOfDays). This is giving me a result of zero for Product A and Product D. However, the Number of Days for Product D is actually null, and I want the calculation to return Null. What is the best way to do this? If I use a simple if statement, I have to do a sum of rows for the total, which I'd like to avoid. Is there a straightforward way to return the result I want (app is attached).

Re: Sum of Null equals zero - How To Resolve

sunny_talwar — Tue, 31 Oct 2017 08:33:52 GMT

Try this

=If(Count(NumberOfDays) > 0, Sum(NumberOfDays))

Re: Sum of Null equals zero - How To Resolve

woshua5550 — Tue, 31 Oct 2017 09:02:19 GMT

Firstly, in your case , it is actually a empty value rather then a null value , inline table can not produce null value

to prove this ,you can use "=NullCount(NumberOfDays)" , the result would be 0,

you can move your date into a Excel file which will produce null value

based on above , change your expression to like this

"=IF(NullCount(NumberOfDays)=0,Sum(NumberOfDays))"