topic Re: How to make Y Axis auto adjust the scale ? in QlikView

How to make Y Axis auto adjust the scale ?

paulyeo11 — Thu, 10 Mar 2016 05:35:34 GMT

Hi All

My issue is when i click on Revenue , the bar look okay , but when i change the slection to display on net profit , the bar look very short. My i knowhow to force QV auto adjust Y axis scale ?

By the way I keep facing the same issue , last time swuehl told me that he cannot find any issue , may be this is due to he is using ver 12 and i am using ver 9.

By the way hope some one can give me some advise how to solve this issue ?

in my next posting i will attach QV Doc

Paul

Re: How to make Y Axis auto adjust the scale ?

paulyeo11 — Thu, 10 Mar 2016 05:36:49 GMT

My QV Doc

Re: How to make Y Axis auto adjust the scale ?

avinashelite — Thu, 10 Mar 2016 05:47:44 GMT

Hi Paul,

As per my knowledge it is not possible we don't have the option to dynamically increase or decrease the size of the chart ....if the two values (in your case bars) have huge difference in number i.e. one value as 10 and other as 100000

it will obviously look small .

One thing you can try is to adjust the Axis scale ...Go to >chart properties > axis > and define your upper and lower limits it the expression ..and uncheck the force 0 ..this might help you you to certain extent

Re: How to make Y Axis auto adjust the scale ?

jagan — Thu, 10 Mar 2016 06:00:03 GMT

HI,

You have negative values in your chart, that is why the X axes position is moving up and the bars become smaller. This is the behaviour of qlikview. If you don't want to display negative numbers then try like this

Properties -> Axes -> Static Min-> Set as 0.

Regards,

jagan.

Re: How to make Y Axis auto adjust the scale ?

jagan — Thu, 10 Mar 2016 06:01:09 GMT

Hi,

Why you are still using QV9? Qlikivew won't support this version anymore. Migrate to QV11 or 12.

Regards,

Jagan.

Re: How to make Y Axis auto adjust the scale ?

paulyeo11 — Thu, 10 Mar 2016 07:05:34 GMT

Hi Jagan

I don't have budget to up grade to latest version.

Paul

Re: How to make Y Axis auto adjust the scale ?

paulyeo11 — Thu, 10 Mar 2016 07:06:32 GMT

Hi Jagan

Thank you for your advise. I cannot set Y Axis to zero, because in net profit it have lost and profit.

Paul

Re: How to make Y Axis auto adjust the scale ?

paulyeo11 — Thu, 10 Mar 2016 07:07:15 GMT

Hi Avinash

Thank you very much for your advise.

Paul

Re: How to make Y Axis auto adjust the scale ?

jagan — Thu, 10 Mar 2016 07:08:05 GMT

Then increase the height of the chart to make bars bigger. This is the only possible way.

Regards,

jagan.

Re: How to make Y Axis auto adjust the scale ?

avinashelite — Thu, 10 Mar 2016 07:09:15 GMT

don't forget to mark the helpful and correct answers