bar offset for stacked bar chart?

Mon, 20 Oct 2014 06:47:43 GMT

Hi,

I have a bar chart that shows revenue on y axis and months on x axis. The chart is further categorized by cities which are shown in legend as different colors. The bars stacked with each segment of stack representing a different city.

What I would like is two graphs. Both chars have the same as above dimensions and expressions .i.e sum(revenue). The only difference is the offset of bars. Below is the description of both kind of offsets

1) The first graph is such that each Bar is offset by the previous bar expression value. The whole bar stack should move up only by the amount of previous expression

2) In this graph, each bar should be offset by the sum of all previous bars expression values (from first bar till previous bar)

Here is the attached data

Arif

Re: bar offset for stacked bar chart?

Gysbert_Wassenaar — Mon, 20 Oct 2014 08:32:14 GMT

See attached qvw

Re: bar offset for stacked bar chart?

MarcoWedel — Mon, 20 Oct 2014 11:19:56 GMT

maybe also helpful?

Waterfall Chart for Bridging data

Waterfall Chart Offest Using Dimensions

Waterfall Chart with Dimension

regards

Marco

topic Re: bar offset for stacked bar chart? in QlikView

bar offset for stacked bar chart?

Re: bar offset for stacked bar chart?

Re: bar offset for stacked bar chart?