Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Hi Matt! Thanks for your help in this "fridays problem" with little bit of tricking I was able solve the problem.