topic Re: How to suppress Null Values in Expressions in QlikView

How to suppress Null Values in Expressions

don_qlikview — Sun, 25 May 2014 17:31:01 GMT

Hello Everyone,

I have a question regarding how to suppress NUll values in expressions. I have two dimensions Name & Country and I have to sum the saleslow and saleshigh in expression. I have summed up the expression but some values have 0's or nulls, so I have the requirement like the pivot chart should not show nulls or zeroes in calculations. So, my question is how can i supress nulls and zeroes in expressions. If anyone have any idea please let me know and I have already tested out suppressing nulls from presentation tab and it doesn't work.

I have attached the sample screen shot for better understanding.

Thanks,

Don

Re: How to suppress Null Values in Expressions

IAMDV — Sun, 25 May 2014 18:44:37 GMT

Hi Don,

Please check my blog post: www.QlikShare.com. Please search for NULL related posts.

Cheers,

Re: How to suppress Null Values in Expressions

hic — Mon, 26 May 2014 20:13:38 GMT

Instead of Sum(Amount), you can use

Sum( If( RangeSum( Amount ) <> 0, Amount ) )

This will exclude both NULLs and zeros.

But it will be slower, since every row will be evaluated. Perhaps you should remove them already in the script?

See more on NULL handling in QlikView

HIC