topic Show zero on stacked bar chart in QlikView

Show zero on stacked bar chart

Tue, 03 Apr 2012 08:39:09 GMT

Is it possible to show the zero on null values in a stacked bar chart?

I managed to do this with a normal bar chart, but I don't know how to achieve this within a stacked bar chart.

Please see the attached picture, I need to show up 0,00 € for bars with null values.

Regards,

Eva

Show zero on stacked bar chart

sivarajs — Tue, 03 Apr 2012 09:39:14 GMT

where it is showing null???

Re: Show zero on stacked bar chart

Tue, 03 Apr 2012 09:52:15 GMT

I have 5 dimension values, where no corresponding value is assigned. Per default, QlikView would not show this values (AP 1, AP 2 umbenannt, AP 1 bearbeitet, ap2, AP 3). Under presentation tab, unchecking no zero values, they show up.

What I need is to display 0,00 € next to these values

Show zero on stacked bar chart

sivarajs — Tue, 03 Apr 2012 10:42:19 GMT

goto dimension and put condition like

if(isnull(Arbeitspaket)=1,0.00,Arbeitspaket)

hope this works...