topic How to present zero and null in bar chart in QlikView

How to present zero and null in bar chart

Rudi — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a bar chart with the following dimension: =Monthname(AsOfPeriod)

And the following expression: =Count({$<Risicocategorie={'midden'},Categorie={'Milieumelding'},
PeriodType={Current},Cal_Year=,Fis_year=,Fis_year2=,Cal_Month=,Cal_MonthYear=,Fis_period=,Date=,
AsOfPeriod={'>=$(=vMaxDate12)<=$(=vMaxDate)'}
>} [Sub categorie])

However I get a bar chart which does not show the zero values (Pls see the attached charts and settings). What am I doing wrong?

Thx.

Rudi

Re: How to present zero and null in bar chart

lockematthewp — Tue, 23 Jul 2019 19:47:29 GMT

I would try to check the 'zero on bars' in the presentation tab. if that does not work, try 'show all bars'.

Re: How to present zero and null in bar chart

ramasaisaksoft — Wed, 24 Jul 2019 05:34:56 GMT

Hi Rudi,

Could you please try to convert the same chart into other format(Straight Table with the help of Fast type change) so that we will know if the chart is showing Null /Zero values then this chart also need to be show. else your data is not correct so check for this conditions data is available or not ?