Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to put summation of not null values?

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: How to put summation of not null values?

Hi Pari,

Thanks for sharing, I got this.

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

I put NEGATIVE sign before EQUAL sign.

Thanks.

2 Replies
Not applicable

Re: How to put summation of not null values?

try :

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

Not applicable

Re: How to put summation of not null values?

Hi Pari,

Thanks for sharing, I got this.

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

I put NEGATIVE sign before EQUAL sign.

Thanks.

Community Browser