Discussion board where members can get started with QlikView.
Could someone kindly look at the following expression I have written in a Pivot table
I would like to show 0 values if the sum of inline_Monthly_Data_A is Null
With the above I am getting - values
Can anyone help?
Hope this helps!
Thank you for your suggestions, but alas, I am still getting Null values
In the properties of your pivot table in presentation tab, does the option "populate missing cells" is checked?
I think the problem is that they are missing values instead of null values, if you check that option you can treat missing values as null values.
Thank you Gabriela
I have found your suggestion very useful and this helps me now
Thanks for your help
it all depends on the "origin" of that NULL.
In general, Qlikview gives your required result by default, with no need of any additional effort.
Let me give you an example.. take this script:
LOAD * INLINE [
Now, b is always associated with NULL, so you would expect to see a NULL in the chart...
If you make a pivot chart with
you will see only a,30
But if you add another expression
You will see also the record of b, with 0 as you required, although it is a sum of NULLs.
So, probably your NULLs are coming from a special situation (like a LEFT join.. or simply an association with missing values?...)
You should try to reproduce your error in a mini-script. This is the most difficult part. Once you have reproduced it, it's very easy to find a solution.
In alternative, if you want, you can send me the qvw and I will fix it for you