topic Show Percents in Pie Chart in QlikView

Show Percents in Pie Chart

Wed, 16 Mar 2011 14:39:02 GMT

How do you get the percentages to show in a pie chart. Each time I try to show the expression in the Number tab, clik show as percent, the output is the whole number (45,320.00%) with a percent sign. How do you get it to display the percent the slice of the pie represents?

Show Percents in Pie Chart

kji — Wed, 16 Mar 2011 14:40:17 GMT

On the Expressions tab, check "Relative" for your expression.

Show Percents in Pie Chart

Wed, 16 Mar 2011 15:37:21 GMT

That worked like a charm. Now, is there a way to have the label be present in the pie chart (not the legend) ?

Show Percents in Pie Chart

boorgura — Wed, 16 Mar 2011 16:03:47 GMT

what do you mean by a label in chart??

Show Percents in Pie Chart

Wed, 16 Mar 2011 16:09:52 GMT

See attached example, the trick is to add more dimensions but make them invisible so they are not added as slices, then click on "show value on data point" so that they do show next to the exsiting slices.

Hope it helps,

Show Percents in Pie Chart

Wed, 16 Mar 2011 16:11:07 GMT

The field name in the axis that the pie slice represents. If 27% of the Pie is represented by Red Pens, the I would like a label in the pie chart representing to read Red Pens either in place of or together with field value.

Show Percents in Pie Chart

Wed, 16 Mar 2011 16:11:40 GMT

Try 'Value on data points'

Thanks

BR.

Show Percents in Pie Chart

Tue, 13 Sep 2011 11:19:10 GMT

Hi, This is exactly what I was looking for. Thanks.

2 questions:

1. In a pie chart the "invisible" option is disabled by me (I copied your Object and it worked fine, but i cannot recreate it myself)

2. The "Other" legend is showing the first Expression only.

any Idea's?

Thanks for your time.

Re: Show Percents in Pie Chart

Anonymous — Fri, 04 Sep 2015 17:25:25 GMT

To add labes, you can place a dimension name inside an expression, and then join it by & :
=[Your_Dimension] & ' '& Your_Calculation

When you cannot see it, you should either change Number Format Settings to "Expression default" or uncheck Relative tab and instead make percentage as a calculation inside your expression (it is just a dividing to show the same value as Relative do). You can try:

=[Your_Dimension]& ' ' &num( (sum [Your_Measure])*100 / sum(TOTAL [Your_Measure]) ), '#.##0,00' ) & ' %'

1) num function lets you format the number

2) TOTAL lets you sum across all your dimensions up (not only one dimension)

3) & joins different types of data (here: numbers and string)

4) ' %' simply adds % in the end of you calculation

Best regards,

Michał

Re: Show Percents in Pie Chart

Thu, 18 Feb 2016 16:08:16 GMT

i dont know, if i do this. my back ground color of expression is coming to the color of other expression, but i am not getting my percentage displayed.

Pls reply

Thank you

Re: Show Percents in Pie Chart

Anonymous — Tue, 01 Mar 2016 09:58:40 GMT

Ganesh can you attach your QVW file?Maybe it would be easier to support you.

Best regards,

Michał

Re: Show Percents in Pie Chart

Tue, 01 Mar 2016 15:16:24 GMT

Thanks for the reply Mehow,

I am unable to send you the attached file, may be i have to connect you on community or follow.

Now, I am following you on community but, it still needs some approval it seems, could you check whether you have to approve it, once it is done, i will attach the file .

Thanks

Re: Show Percents in Pie Chart

Anonymous — Wed, 02 Mar 2016 11:07:47 GMT

Maybe you can post it here, in the discussion?

Re: Show Percents in Pie Chart

Thu, 10 Mar 2016 15:11:05 GMT

Hi,

can you see , i have posted my problem along with my qvd file in the discussion.

Pls help me with that

Re: Show Percents in Pie Chart

Mon, 14 Mar 2016 14:32:03 GMT

Hi mehow1989,

could you please see my document that i posted in the discussion

Re: Show Percents in Pie Chart

settu_periasamy — Tue, 15 Mar 2016 02:43:44 GMT

Hi Ganesh,

Check it here.. Re: show percents in pie chart