topic Re: Handling Null Values in Expression (Sum) in QlikView

Handling Null Values in Expression (Sum)

rishimessi19 — Mon, 01 Aug 2016 20:48:33 GMT

I have a data set (Below Picture) with Dim and Sales as two attributes. I want to show sum in a straight table. I see that '0' is being displayed when we sum two null values. How can we display '-' when we have missing values in a sum expression?

Re: Handling Null Values in Expression (Sum)

swuehl — Mon, 01 Aug 2016 21:33:51 GMT

Have a look at

Re: Nulls and Zeros in SUM function

and the other referenced thread therein also.

Re: Handling Null Values in Expression (Sum)

trdandamudi — Mon, 01 Aug 2016 21:33:57 GMT

You can try below expression:

=If(Sum(Sales) = 0, '-',Sum(Sales))

Re: Handling Null Values in Expression (Sum)

sunny_talwar — Mon, 01 Aug 2016 22:45:41 GMT

Or may be this:

Sum(Sales) * (Avg(Sales)/Avg(Sales))