topic Re: Percentages in Pie Chart in QlikView

Percentages in Pie Chart

anuradhaa — Thu, 04 Oct 2012 11:31:48 GMT

Hi All,

I have created a pie charts,

The Values are

A = 785

B= 168

C= 20

D= 5

I need to show those values and precentages in my pie chart,

Please help me to do that

Thanks

Re: Percentages in Pie Chart

fdelacal — Thu, 04 Oct 2012 11:34:01 GMT

in the expressions check relative

Re: Percentages in Pie Chart

anuradhaa — Thu, 04 Oct 2012 11:42:07 GMT

Thank, but how can i get the numeric values also.

IT shows only the precentages

Re: Percentages in Pie Chart

fdelacal — Thu, 04 Oct 2012 11:46:07 GMT

copy the expresion and paste to a new one.. yo have the same value no check relative in the new one.

Re: Percentages in Pie Chart

anuradhaa — Thu, 04 Oct 2012 11:50:22 GMT

But i need to have that in the same graph,

if i add it as a new one in the same graph it doesn't work

Thanks

Re: Percentages in Pie Chart

fdelacal — Thu, 04 Oct 2012 11:58:11 GMT

i think you can´t do that with only one chart.. you can do a group with both expression and show it.

Re: Percentages in Pie Chart

anuradhaa — Thu, 04 Oct 2012 12:10:29 GMT

ok thanks

Re: Percentages in Pie Chart

MayilVahanan — Thu, 04 Oct 2012 12:48:49 GMT

You can group the expression and you can able to show the both relative and values in same pie chart but not at the same time..

Hope that helps

Re: Percentages in Pie Chart

Anonymous — Thu, 04 Oct 2012 13:57:18 GMT

If you create a second expression (a copy of first) select "values on datapoint" and remove relative.

Then go to the presentation tab and select "show numbers in legend" then you will get a chart that looks like the one in the image. Not sure if this is what you want?

Re: Percentages in Pie Chart

jagan — Fri, 05 Oct 2012 11:58:32 GMT

Hi Anuradha,

Please find attached document hope it helps you.

Regards,

Jagan.

Re: Percentages in Pie Chart

anuradhaa — Mon, 08 Oct 2012 11:34:24 GMT

Thanks,

It works .

But in my ledgend i have 15 . so when i show the ledgend it is on the pie chart.

do you know how to fix this.

Thanks

Re: Percentages in Pie Chart

jagan — Mon, 08 Oct 2012 14:01:25 GMT

Hi,

Can you attach the file or image you are working. I think your Legend falls on the pie chart, if my understanding is correct then hold ctrl and shift buttons and adjust the legend and chart as you require.

Hope this helps you.

Regards,

Jagan.