Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

bar offset for stacked bar chart?

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

2 Replies
Gysbert_Wassenaar

See attached qvw


talk is cheap, supply exceeds demand