topic Re: Split axis in bar/combo chart in QlikView

Split axis in bar/combo chart

Wed, 21 May 2014 03:50:36 GMT

Hi, I have a normal bar chart with 2 expressions and I want to create a line chart representing the percentage difference between those 2 expressions. However, the percentage is very small and it will just seem like a straight line on the x-axis. So I want to bring the line chart axis on top of the bar chart axis so that the line chart is clearer to see. All this is still in one object/chart area. How can I do this? Thanks.

Re: Split axis in bar/combo chart

Wed, 21 May 2014 04:24:57 GMT

you can make 2 charts and make them sit on each other.... and then use the 'Layer' option in the 'Layout' tab of the chart to control which is at the front and which is at the bottom.

Re: Split axis in bar/combo chart

Anonymous — Wed, 21 May 2014 05:01:13 GMT

Why not you use the second axes for the difference one

For Expression 1 and Expression 2 use Left(Bottom) and

Expression 3 use Right(Top).

You can find it in Axes tab, under Position.

Regards

Nitin

Re: Split axis in bar/combo chart

Wed, 21 May 2014 05:25:43 GMT

Thank you!