Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I'm working on a Bar chart, where i have 3 expressions:
Total = Sum(ID)
Filled = Sum(Filled)
Util. % = Filled/TOtal
When i represent in a bar chart, the Util% bar is very short to view, since its corresponding values (Total & Filled) were high.
I wanna set max. value of the "Util.%"as the "Total value" such that the "Util.%" bar is visible.
Please find the attached qvw.
Go to Axes tab
Choose third expression, and check (Right/Top)
Hi,
Go to axes tab and select Position of expression as right/left
Hi It worked.
Thank you.
Can you please tell me what does the "Right(Top)" bottom does.
Hi It worked.
Thank you.
Can you please tell me what does the "Right(Top)" bottom does.
It basically represents the values on Y axis, but to the right side. By default chart represents the Y axis values on left side. Generally when we have two expressions( one with numerical values & one with %) , we divide either of the expression on right or left. If we show both expression on same axis side % value will always be have small values so the same issue which you faced right now will occur.
You can change (top/bottom right/left) axe for each expression.
Play around with this parameter and see what happens
Be Qlik