Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Why you are still using QV9? Qlikivew won't support this version anymore. Migrate to QV11 or 12.
Regards,
Jagan.
My QV Doc
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
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.
Hi,
Why you are still using QV9? Qlikivew won't support this version anymore. Migrate to QV11 or 12.
Regards,
Jagan.
Hi Jagan
I don't have budget to up grade to latest version.
Paul
Hi Jagan
Thank you for your advise. I cannot set Y Axis to zero, because in net profit it have lost and profit.
Paul
Hi Avinash
Thank you very much for your advise.
Paul
Then increase the height of the chart to make bars bigger. This is the only possible way.
Regards,
jagan.
don't forget to mark the helpful and correct answers