Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

hansdevr
Contributor II

Split axis leads to overlapping values...

Dear all,

I have prepared a line chart, which shows two values, which should be compared. Because these values are far apart, I have used split axis. As you can see, the min and max values of the respective axises overlap. How can I avoid this?

Any help is welcome!

1 Solution

Accepted Solutions

Re: Split axis leads to overlapping values...

Well, usually people put labels for one of the axis on the left and the labels for the other on the right. That way no overlap is possible. I'd seriously consider two charts above one another. That will still make it fairly easy to make comparisons between them. Alternatively, if the comparison is so important then normalize them both so they show the relative change against an index value. Since you're then displaying ratios instead of absolute values the two lines can share a common y-axis.


talk is cheap, supply exceeds demand
4 Replies

Re: Split axis leads to overlapping values...

How can I avoid this?

Simple. Never use split axes. Always create two separate charts instead. There's no good use case for split axes. The alternatives are always better to interpret and understand.


talk is cheap, supply exceeds demand
hansdevr
Contributor II

Re: Split axis leads to overlapping values...

Hahaha!! Good answer, but not exactly what I wanted to read.. The reason I want these graphs in split axis, is that there is a lot of control involved in setting up these graphs, and I'm too lazy to do it all twice.. No seriously, these graphs represent insurance reserve and IBNR stats, which should be closely compared for several years. Is there no way to avoid the overlap when I insist in using split axis?

Re: Split axis leads to overlapping values...

Well, usually people put labels for one of the axis on the left and the labels for the other on the right. That way no overlap is possible. I'd seriously consider two charts above one another. That will still make it fairly easy to make comparisons between them. Alternatively, if the comparison is so important then normalize them both so they show the relative change against an index value. Since you're then displaying ratios instead of absolute values the two lines can share a common y-axis.


talk is cheap, supply exceeds demand
hansdevr
Contributor II

Re: Split axis leads to overlapping values...

Your last sentence made sense. Thanks!!

Community Browser