topic Double y-axis & dimension Charts? in QlikView

Double y-axis & dimension Charts?

Mon, 27 Sep 2010 20:46:58 GMT

Is there any way in Qlikview to recreate this kind of chart?

Double y-axis & dimension Charts?

pover — Mon, 27 Sep 2010 21:01:21 GMT

Bryan,

Here's an example. What you have to do is go to the Axes tab, select an expression and define it as having the position right (top) and then you check the split axes option.

I usually use this feature for line graphs so I hadn't noticed that in the bar graphs the bars don't match up in the dimension label. Maybe somebody has a solution for that.

Regards.

Double y-axis & dimension Charts?

Mon, 27 Sep 2010 21:20:17 GMT

Is there a way to keep one dimension on one side of the graph and the other on the other side?

And yes the bars not being on top of one another is kind of obnoxious.

Double y-axis & dimension Charts?

Anonymous — Mon, 27 Sep 2010 21:31:07 GMT

Same tab in the chart properties, see Position - left(bottom) and right(top)

Double y-axis & dimension Charts?

Mon, 27 Sep 2010 21:36:28 GMT

I tried tinkering with that, it didn't seem to have any effect. I see the same results in the example Karl provided.

Double y-axis & dimension Charts?

Anonymous — Mon, 27 Sep 2010 21:40:47 GMT

You're right, it doesn't work with split axes. Looks like a bug... 😞

Double y-axis & dimension Charts?

pover — Mon, 27 Sep 2010 21:44:16 GMT

QlikView seems to ignore the left (bottom) and right (top) options when you enable the split axis option.

Maybe this isn't the prettiest solution, but creating two graphs with the same dimension and aligning them up so that one is exactly on top of the other. On the top graph you can disable the Show Legend checkbox so that the dimension value shows only one time.

Regards.

Double y-axis & dimension Charts?

Mon, 27 Sep 2010 21:53:03 GMT

That's what I was thinking I might end up doing.

Thanks for the help!