Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Several Stacked Bars in a Bar Chart

Hi all! I have little problem, which I was hoping that you guys could help me. Im generating a bar chart, which includes four figures. These figures are gathered trough four expressions. Let say they are A,B,C and D. From these A and B are figures derived from same action. As also C and D are a pair. I would like to show these figures in my bar chart so that, A and B would be in one stacked bar, and C+D in other. In this way I could see invidual numbers for each figures and also sum for A+B and C+D.

Is there any way to achieve this?

1 Solution

Accepted Solutions
matt_crowther
Specialist
Specialist

That's a good 'Friday Problem'.

Attached is my solution and to be honest it's a little strange on Qlikviews part:

Dual Stacked.PNG

Qlikview appears to only allow you to select the 'Stacked' option when you're using 2 dimensions - one for the axis and one for the 'stacking-split' but in your requirement you need 3 - an additional one to split the stacks into 2 groups.

The trick in this example is first to create a chart with 2 dimensions and the required expression, then select 'Stacked', 'Apply' that to the chart, now go back and add your 3rd dimension - hey presto it works; look at the 'Style' tab and 'Subtype' will be greyed out.

Hope that solves it.

Alt' Best,

Matt - Visual Analytics Ltd

View solution in original post

2 Replies
matt_crowther
Specialist
Specialist

That's a good 'Friday Problem'.

Attached is my solution and to be honest it's a little strange on Qlikviews part:

Dual Stacked.PNG

Qlikview appears to only allow you to select the 'Stacked' option when you're using 2 dimensions - one for the axis and one for the 'stacking-split' but in your requirement you need 3 - an additional one to split the stacks into 2 groups.

The trick in this example is first to create a chart with 2 dimensions and the required expression, then select 'Stacked', 'Apply' that to the chart, now go back and add your 3rd dimension - hey presto it works; look at the 'Style' tab and 'Subtype' will be greyed out.

Hope that solves it.

Alt' Best,

Matt - Visual Analytics Ltd

Not applicable
Author

Hi Matt! Thanks for your help in this "fridays problem" with little bit of tricking I was able solve the problem.