topic Re: Combochart 2 axes position in QlikView

Combochart 2 axes position

wenkew186 — Mon, 08 Aug 2016 10:21:00 GMT

hi expert,

I have a combo chart, and have 2 axes like picture. but I want change the position for this 2 axes. the bar should be downstairs, and the line should be upstairs. how to arrived it? by the way, how to make the step number is integer on bar axes?

best regards!

Re: Combochart 2 axes position

marcus_sommer — Mon, 08 Aug 2016 10:55:07 GMT

To move the bars on the bottom and the lines above you could change the order of your expressions (promote button) or within the tab axis you will find the settings for splitting a chart and which axis should be used in mid-right area from this tab. For changing the number-presentation go to the tab numbers and change there the settings of your expressions.

- Marcus

Re: Combochart 2 axes position

marjan_it — Mon, 08 Aug 2016 10:57:05 GMT

can you attach your file?!

Re: Combochart 2 axes position

wenkew186 — Tue, 09 Aug 2016 01:53:21 GMT

Thanks Marcus,

Expression sort change can not change the Bar to downstairs. And I have setting the split axes percentage, but it is just distribute the space size for Bar and Line. but not change the position.

see, there have 2 axes that I have split it, Bar and Line. I need show the Bar beneath Line.

the new picture is closed my require, but just the axes in right. I need the axes in left and chart like below. and not show the ".0" on bar axes number. that's my totally require.

Re: Combochart 2 axes position

wenkew186 — Tue, 09 Aug 2016 02:29:15 GMT

marjan, put the sample file here, thanks for help!

Re: Combochart 2 axes position

wenkew186 — Tue, 09 Aug 2016 02:32:19 GMT

for the sample file, I want make the axes to left side, and no changes on other.

Re: Combochart 2 axes position

sunny_talwar — Tue, 09 Aug 2016 02:41:41 GMT

Like this?

Added a new expression to the top (highlighted by circling it in the legend)

Re: Combochart 2 axes position

marjan_it — Tue, 09 Aug 2016 05:11:09 GMT

in axes tab and in position section you can select left or right.

Re: Combochart 2 axes position

wenkew186 — Thu, 11 Aug 2016 08:22:53 GMT

Thank you very much, Sunny! that's solved my problem totally.

Re: Combochart 2 axes position

wenkew186 — Thu, 11 Aug 2016 08:32:26 GMT

just why there add a expression to first column will be make the axis to another side? can you educate me if possible?

Re: Combochart 2 axes position

sunny_talwar — Thu, 11 Aug 2016 09:08:52 GMT

Really difficult to say why something the way they are. It might be a bug or intended feature, but that's just how it is that the first expression drives your axis position for some reason