topic Several Stacked Bars in a Bar Chart in QlikView

Several Stacked Bars in a Bar Chart

Fri, 04 Nov 2011 11:09:40 GMT

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?

Re: Several Stacked Bars in a Bar Chart

matt_crowther — Fri, 04 Nov 2011 11:50:18 GMT

That's a good 'Friday Problem'.

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

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

Several Stacked Bars in a Bar Chart

Fri, 04 Nov 2011 12:04:33 GMT

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