How can we handle Null values & Missing values with drilldown groups in Barchart

[madhubabum]

Hi All

        In the following ..

        How we can suppress 'Zero' Values & 'Missing' Values

Thanks To All

Madhu

       

[oknotsen]

If this option is available, you can find it on the bottom of the Presentation tab, slightly left of the middle.

[Agis-Kalogiannis]

Have you tried suppressing the null values from the dimensions tab?

You can click on the Suppress when value is null checkbox.

[madhubabum]

Hi, Agis Kalogiannis

I tried but, it's can't be working.

Thanks

Madhu

[hic]

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.

HIC

[Agis-Kalogiannis]

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?

Thanks