6 Replies Latest reply: Jun 30, 2015 4:45 PM by Clever Anjos

# Calculating percentage in the bar chart

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.

• ###### Re: Calculating percentage in the bar chart

Go to Axes tab

Choose third expression, and check (Right/Top)

• ###### Re: Calculating percentage in the bar chart

Hi It worked.

Thank you.

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

• ###### Re: Calculating percentage in the bar chart

Hi,

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

• ###### Re: Calculating percentage in the bar chart

Hi It worked.

Thank you.

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

• ###### Re: Calculating percentage in the bar chart

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.

• ###### Re: Calculating percentage in the bar chart

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

Play around with this parameter and see what happens

Be Qlik