topic Re: Display the Percentage in the Bar Chart in QlikView

Display the Percentage in the Bar Chart

Wed, 01 Aug 2012 10:43:59 GMT

It would be greatful, if some one could help with my requirement.

Below is the report which i am working on.

I want to display the Percentage(0, 50% and 100%) instead of 1K, 10K,....10M.

If i increase the slider 20, my values in the chart should increase the revenue by 20% and display the value accordingly.

I have used the expression: Sum([AVERAGE AMOUNT] * (1 + (vModifier / 100))) for the chart.

Dimensions - SCHEME & CIRCLE

Expression - REVENUE

AVERAGE AMOUNT is the Revenue

vModifier - variable.

How do i achieve this?

Thank You in advance.

Re: Display the Percentage in the Bar Chart

jonathandienst — Wed, 01 Aug 2012 10:48:26 GMT

To get a % scale, I think you need this as the expression:

Sum([AVERAGE AMOUNT] * (1 + (vModifier / 100))) / Sum(Total <Circle> [AVERAGE AMOUNT])

And change the format in the chart properties | Numbers tab to %.

Hope that helps

Jonathan

Re: Display the Percentage in the Bar Chart

Thu, 02 Aug 2012 04:05:23 GMT

Jonathan

I tried the solution which you provided:

Sum([AVERAGE AMOUNT] * (1 + (vModifier / 100))) / Sum(Total <Circle> [AVERAGE AMOUNT])

Sum([AVERAGE AMOUNT] * (1 + (vModifier / 100))) / Sum(Total <CIRCLE> [AVERAGE AMOUNT])

In my report CIRCLE is a Dimension.

When using <CIRCLE> (Dimension), the below report is displayed.

When using <Circle>, the below report is displayed.

Can you guide me where am i going wrong?

Thank You.

Re: Display the Percentage in the Bar Chart

jonathandienst — Fri, 03 Aug 2012 10:22:40 GMT

Please post a sample of your app. I need to look at the data to understand your chart.

I think the field should have been CIRCLE. Circle was a typo imy expression. To see what is actually on the axis, turn off the percent format on the axis.

Regards

Jonathan

Re: Display the Percentage in the Bar Chart

Mon, 06 Aug 2012 10:56:08 GMT

Jonathan,

As i am using QV 11 Personal Edition. No one can open the qvw file which i have developed. Anyway i have attached for your reference. Do try to open.

If cant open the file please do revert back.

If i try to remove the Percentage in Chart Properties ---- Number(Fixed To), i am getting the below result in the Y Axis.

Thank You.

Re: Display the Percentage in the Bar Chart

jonathandienst — Mon, 06 Aug 2012 19:34:23 GMT

Vinod

Anyone with a license can read the file your created - its only other PE users that cannot open the file. I will have a look

Regards

Jonathan

Re: Display the Percentage in the Bar Chart

jonathandienst — Mon, 06 Aug 2012 19:49:50 GMT

Vinod

Not sure if you are able to open the attachment. All I did was recreate the chart - it seems your one somehow got corrupted. The new chart behaves as I would expect. For some reason the image feature is not working so I have attached the picture as well.

Regards

Jonathan

Re: Display the Percentage in the Bar Chart

Tue, 07 Aug 2012 03:37:24 GMT

Jonathan,

You are rite. The attached qvw file is not opening for me.

The picture which you have attached is the result which i need to get.

The expression matches with my report and with your picture.

I am not sure where i have gone wrong.

Please do check with this also,

In Chart Properties - Number

I have selected Integer and checked the show in Percent(%)

Have done anything wrong in this chart Property(Number)?

Thank You.

Re: Display the Percentage in the Bar Chart

jonathandienst — Tue, 07 Aug 2012 08:50:56 GMT

Vinod

Delete the chart and start again. The one in the file you posted is corrupted so you will not get that one to work properly. That's what I did to get the chart picture that I posted

Regards

Jonathan

Re: Display the Percentage in the Bar Chart

Tue, 07 Aug 2012 08:55:46 GMT

Sure Jonathan, will give it a try.

Re: Display the Percentage in the Bar Chart

Wed, 08 Aug 2012 10:17:10 GMT

Jonathan,

The report is working perfectly. U were right, the report was a corrupted one.

I designed it once again and is working.

Thank you very much for your help.