topic Chart with 2 Y axis - X axis in unexpected position in QlikView

Chart with 2 Y axis - X axis in unexpected position

Thu, 02 Jan 2014 13:21:43 GMT

Hi All,

I've created a combo chart to show absolute values in bars and percentage change as a line. Two separate Y axes - one for the absolute and one for the percentage. Percentage can be negative as well as positive, absolutes positive only in the range of 0 - 500,000.

When the chart is displayed the absolute values axis is very compressed at the top of the chart, moving the X axis right up:

(I know it's not in the image above, but there is an axis of the right of 0 at the X to 100% at the bottom right, in 20% increments),

Is there anyway of forcing the X-axis to be at the centre of the chart so that the absoulute values are more readable?

Thanks,

Rory.

Re: Chart with 2 Y axis - X axis in unexpected position

Thu, 02 Jan 2014 13:29:42 GMT

You can set a static min and max for each expression. Set the static max for your bar chart expression to be higher. You can either use a static value, or an expression such as =max(myvalue) + 1000

Re: Chart with 2 Y axis - X axis in unexpected position

Thu, 02 Jan 2014 13:41:43 GMT

Hi Kai,

Thanks for the suggestion, but all that did was change the y-axis values above the X-axis. It didn't move the x-axis down towards the centre of the chart at all.

Thanks,

Rory.

Re: Chart with 2 Y axis - X axis in unexpected position

Anonymous — Thu, 02 Jan 2014 14:03:20 GMT

Rory

I guess that on your Chart Axes tab you have the Split Axis selected.

Just below this is the Primary %, have you tried adjusting this ?

Best Regards, Bill

Re: Re: Chart with 2 Y axis - X axis in unexpected position

Thu, 02 Jan 2014 14:10:52 GMT

I just tried it with some test data and it looks fine. Can you compare your solution with mine to see where the difference is? See qvw attached.

Re: Re: Chart with 2 Y axis - X axis in unexpected position

Thu, 02 Jan 2014 14:16:25 GMT

btw I get the same result if I use very large numbers up to 500,000

Re: Re: Re: Chart with 2 Y axis - X axis in unexpected position

swuehl — Thu, 02 Jan 2014 14:18:25 GMT

Kai,

I can reproduce this when using a mixed sign value range for one expression.

Check attached.

Re: Chart with 2 Y axis - X axis in unexpected position

Thu, 02 Jan 2014 14:47:36 GMT

OK.... so I attached my laptop to a projector and it then fixed itself. Not sure if it was just a display bug or a dashboard refresh issue. Very strange.

So anyway, fixed now, but thank you for the suggestions everyone!

Re: Chart with 2 Y axis - X axis in unexpected position

Thu, 02 Jan 2014 14:53:25 GMT

Ouch. Looks horrible.

Re: Chart with 2 Y axis - X axis in unexpected position

prasannarc_jbs2 — Wed, 02 Apr 2014 04:55:48 GMT

Dear Folks,

I am also having the same problem with the Scale when the chart is a showing 2 KPI with two axis.

Currently my chart is looking like this, The scale inside chart becomes illegible for few selections

If I use the Static Max property it works good for some of the selections but not for all, Below first screenshot if I deselect forced 0 property for both the expression.

Is there any other way to resolve this?

Thank you in advance.

Best Regards,

PRC

Re: Re: Chart with 2 Y axis - X axis in unexpected position

arjunkrishnan — Wed, 02 Apr 2014 05:21:44 GMT

Hi frds See This Attachment This Will Useful For U....

2 Y-Axis with One X-Axis With Expected Posion

Re: Re: Chart with 2 Y axis - X axis in unexpected position

prasannarc_jbs2 — Wed, 02 Apr 2014 14:52:22 GMT

No I think you have got me wrong Arjun.

In My case, I have a chart (Bar chart) with two expressions (KPI). one of the KPI can have negative values.

When I see the chart for some selections, the scale is not appearing properly on the chart as you can see my first screenshot.