Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

madhubabum
Contributor

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

Hi All

        In the following ..

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

Thanks To All

Madhu

        1.png

5 Replies
oknotsen
Honored Contributor III

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

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

May you live in interesting times!
Employee
Employee

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

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

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

madhubabum
Contributor

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

Hi, Agis Kalogiannis

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

Thanks

Madhu

Employee
Employee

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

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

Employee
Employee

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

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

Community Browser