topic Split axis leads to overlapping values... in QlikView

Split axis leads to overlapping values...

hansdevr — Wed, 23 Mar 2016 07:50:37 GMT

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!

Re: Split axis leads to overlapping values...

Gysbert_Wassenaar — Wed, 23 Mar 2016 07:56:16 GMT

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.

Re: Split axis leads to overlapping values...

hansdevr — Wed, 23 Mar 2016 08:01:18 GMT

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...

Gysbert_Wassenaar — Wed, 23 Mar 2016 08:07:53 GMT

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.

Re: Split axis leads to overlapping values...

hansdevr — Wed, 23 Mar 2016 08:28:31 GMT

Your last sentence made sense. Thanks!!