topic How to put summation of not null values? in QlikView

How to put summation of not null values?

Fri, 03 Aug 2012 07:08:30 GMT

Hi,

I want to put the summation of Cost in a text object, depends on the dimension, say for example Item,

but there are NULL item included in the summation, how to suppress null in text object.

Is this possible?

Thanks,

Bill

Fri, 03 Aug 2012 07:20:15 GMT

try :

=sum({$<dimension={"*"}>}value)

Fri, 03 Aug 2012 07:56:56 GMT

Hi Pari,

Thanks for sharing, I got this.

sum({<DIMENSION-= {$(null())} >} VALUE)

I put NEGATIVE sign before EQUAL sign.

Thanks.