topic Bar Chart in QlikView

Bar Chart

Fri, 07 Oct 2011 14:18:25 GMT

Hi,

i have created a bar chart with Quarter as X axis and Amount as Y axis. I am getting the values correctly. But suppose there is no value for Quarter Q2 then the X axis is not showing the label Q2 and there is no value at Y Axis.

I want to show the X Axis Q2 with Y Axis vlaue as 0. Is it possible to do it ?

Bar Chart

SunilChauhan — Fri, 07 Oct 2011 14:25:45 GMT

chart properties-> presentation->supress zero values->uncheck and ok

Bar Chart

kji — Fri, 07 Oct 2011 14:25:55 GMT

Check that "Suppress Zero-Values" is unchecked (Presentation tab) and you might also want to have "Show All Values" enabled for Quarters (Dimension tab).

Re: Bar Chart

Fri, 07 Oct 2011 14:53:05 GMT

Thanks Sunil and Johan,

Sorry i have edited the rsponse it showing as expected after chaning the properties inthe presentation tab.But it is showing as Q1,Q2,Q3,Q4,- It is showing '-' as one of dimesion value. I am not sure where it is coming from. How to eliminate this

Re: Bar Chart

Fri, 07 Oct 2011 16:00:50 GMT

In the chart Properties, go to Dimensions and check Supress when value is Null.

Bar Chart

SunilChauhan — Sun, 09 Oct 2011 15:23:30 GMT

you need to follow this

chart properties-> presentation->supress zero values->uncheck and ok

see my post above

and not check show all value .then it will not show you '-'

and also required to supress null value.