Discussion Board for collaboration on QlikView Layout & Visualizations.
In the following ..
How we can suppress 'Zero' Values & 'Missing' Values
Thanks To All
If this option is available, you can find it on the bottom of the Presentation tab, slightly left of the middle.
Have you tried suppressing the null values from the dimensions tab?
You can click on the Suppress when value is null checkbox.
Hi, Agis Kalogiannis
I tried but, it's can't be working.
But the values you have in your chart aren't zero. You can see small, thin bars, and this means that there is a value. Then QlikView will not suppress the bars.
The only reason that it shows "0" is that you have some rounding, probably in the formatting.
I think Henry is right. Can you please check your number format and let us know?
Or maybe try to change it to Number with 2 decimal places and let us know if you see numbers there instead of zero?