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

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

madhubabum — Fri, 12 Jun 2015 06:13:01 GMT

Hi All

In the following ..

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

Thanks To All

Madhu

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

oknotsen — Fri, 12 Jun 2015 12:18:05 GMT

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

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

Agis-Kalogiannis — Fri, 12 Jun 2015 12:25:39 GMT

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

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

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

madhubabum — Fri, 12 Jun 2015 12:30:30 GMT

Hi, Agis Kalogiannis

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

Thanks

Madhu

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

hic — Fri, 12 Jun 2015 17:00:41 GMT

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

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

Agis-Kalogiannis — Fri, 12 Jun 2015 20:24:32 GMT

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