How to suppress Null Values in Expressions

[don_qlikview]

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

[IAMDV]

Hi Don,

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

Cheers,

DV

[hic]

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