topic Re: Calculating percentage in the bar chart in QlikView

Calculating percentage in the bar chart

markgraham123 — Tue, 30 Jun 2015 18:02:51 GMT

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.

Re: Calculating percentage in the bar chart

Clever_Anjos — Tue, 30 Jun 2015 18:15:42 GMT

Go to Axes tab

Choose third expression, and check (Right/Top)

Re: Calculating percentage in the bar chart

Kushal_Chawda — Tue, 30 Jun 2015 18:17:38 GMT

Hi,

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

Re: Calculating percentage in the bar chart

markgraham123 — Tue, 30 Jun 2015 18:25:26 GMT

Hi It worked.

Thank you.

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

Re: Calculating percentage in the bar chart

markgraham123 — Tue, 30 Jun 2015 18:25:32 GMT

Hi It worked.

Thank you.

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

Re: Calculating percentage in the bar chart

Kushal_Chawda — Tue, 30 Jun 2015 18:46:12 GMT

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

Clever_Anjos — Tue, 30 Jun 2015 20:45:22 GMT

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

Play around with this parameter and see what happens

Be Qlik