topic Pie Chart - Values on Data Points in QlikView

Pie Chart - Values on Data Points

PradeepReddy — Fri, 04 Jul 2014 07:33:37 GMT

Hi All,

Requirement: I need to show case both Number and Relative% values in Pie-Chart.

Is it possible to showcase that scenario? I am attaching the sample screen shot.

Thanks,

Pradeep

Re: Pie Chart - Values on Data Points

Fri, 04 Jul 2014 07:54:33 GMT

Try this in expression

dual( sum(number) & chr(10) &

num( sum(number)/sum(total number), '##%')

, sum(number))

Hope this will help

Re: Pie Chart - Values on Data Points

alexandros17 — Fri, 04 Jul 2014 08:11:04 GMT

It is not possible to show values inside the pie as you need ....

Re: Pie Chart - Values on Data Points

PradeepReddy — Fri, 04 Jul 2014 13:30:51 GMT

sorry for the late reply....

Even if we can show out side of the chart also fine...

Regards

Pradeep

Re: Pie Chart - Values on Data Points

alexandros17 — Fri, 04 Jul 2014 13:39:28 GMT

Simply check "values on data point" ....

Re: Pie Chart - Values on Data Points

PradeepReddy — Mon, 07 Jul 2014 10:24:21 GMT

Sorry for the late reply...

I have tried this option too and it is not giving both values...

Re: Pie Chart - Values on Data Points

Mon, 07 Jul 2014 10:39:58 GMT

Keep two expressions for the same KPI

PFA the image to demonstrate the same. For one expression, uncheck the relative, text on axis and text as popup option.

For the second expression, check all the three options.

Also in presentation tab, check the "Show numbers as legend " option.

Re: Pie Chart - Values on Data Points

juleshartley — Mon, 07 Jul 2014 10:47:04 GMT

Deepak is right - you should be able to have two expressions with the same values set to display the labels differently.

Re: Pie Chart - Values on Data Points

mahesh_agrawal — Mon, 07 Jul 2014 10:48:20 GMT

The values can't be shown for the kind of pie chart you want to show.

Re: Pie Chart - Values on Data Points

sudeepkm — Mon, 07 Jul 2014 10:51:40 GMT

If you are using the 3D style then I do not think the values can be displayed on the data points.

You may show the values on the Legend in that case (Show Numbers in Legend). Can you please tell me which style of the PIE chart you are using?

Re: Pie Chart - Values on Data Points

PradeepReddy — Tue, 08 Jul 2014 07:03:43 GMT

I am using normal style pie-chart only.

I am trying to display the same expression value in numbers as well as in relative % as shown in firts post.

Re: Pie Chart - Values on Data Points

sudeepkm — Tue, 08 Jul 2014 08:56:55 GMT

In that case as other folks have advised the "Values on Data point" option should work.

If possible then can you please share your QVW here it will help us to identify the issue.

Re: Pie Chart - Values on Data Points

Tue, 08 Jul 2014 10:00:12 GMT

Did you see the file attached by me earlier.?