Calculating percentage in the bar chart

[markgraham123]

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.

[Clever_Anjos]

Go to Axes tab

Choose third expression, and check (Right/Top)

[Kushal_Chawda · Accepted solution]

Hi,

Go to axes tab and select Position of expression as right/left

[markgraham123]

Hi It worked.

Thank you.

Can you please tell me what does the "Right(Top)" bottom does.

[markgraham123]

Hi It worked.

Thank you.

Can you please tell me what does the "Right(Top)" bottom does.

[Kushal_Chawda]

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.

[Clever_Anjos]

You can change (top/bottom right/left) axe for each expression.

Play around with this parameter and see what happens

Be Qlik