topic Consumption bar chart suggestion in QlikView

Consumption bar chart suggestion

Mon, 15 Mar 2010 15:42:17 GMT

hallo,

i have a simple table of consumption of items. this table contain data like this:

OUTID OUTDATE OUTQTA OUT DEPARTMENT

i use a bar chart to sum the consumptions and show the monthly/year trend of the consumptions.

what i want to reach is to have on the Axis all the months, included those months that

are not listed in any row of OUT table.

otherwise the trend is not well readable coz sometime when there is NO consumption for months

of one product the graph jump from one month to the next without set the BAR on the 0Value months.

any idea?

thx

SV:Consumption bar chart suggestion

gandalfgray — Mon, 15 Mar 2010 16:16:08 GMT

Try

Chart Properties > Axes

..then check the "Continuous" box for the Dimension Axis

hth

SV:Consumption bar chart suggestion

Mon, 15 Mar 2010 20:09:54 GMT

thanks for the help.

i set continuous with a static step of 30 (day) but now i have some problem

to show data point and scroll-bars.

I tried to set to 20 the number of datapoint visible and allow to show scrollbars

(horizontal) when needed.

results: if a scroll with the mouse i see on the graph the data point scrolling, but no way to visualize the scrollbar in the bottom of the chart. looks invisible! but working with the scrollwheel of the mouse.

SV:Consumption bar chart suggestion

Wed, 17 Mar 2010 16:13:07 GMT

up?