topic Re: values inside the pie chart? in QlikView

values inside the pie chart?

Akina0929 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all ,

I have cheated pie chart country as dimension and sum(sales) as expression, in this chart I want show values inside and dimension values in out side , I used following style ,please help me how can i achieve.

Thanking you,

Anji

Re: values inside the pie chart?

Kushal_Chawda — Thu, 13 Jul 2017 10:31:09 GMT

Value inside and dimension outside? Can you please draw the exact output?

Re: values inside the pie chart?

Frank_Hartmann — Thu, 13 Jul 2017 10:38:01 GMT

clone the chart.

make the copy smaller.

make everything transparent except the data labels.

lay the copied chart on top of the original.

hope this helps

Re: values inside the pie chart?

Akina0929 — Thu, 13 Jul 2017 10:42:06 GMT

Hi kushal,

please find the following image.

Re: values inside the pie chart?

Frank_Hartmann — Thu, 13 Jul 2017 10:52:22 GMT

see attached file

Re: values inside the pie chart?

Kushal_Chawda — Thu, 13 Jul 2017 11:01:42 GMT

It will be difficult achieve the exact pie chart with QlikView native pie chart. You need to have an extension.

Alternative could be like below

=dual(Country&chr(10)&num(sum(Sales)/sum(TOTAL Sales),'#0%'),sum(Sales))