topic Re: Show two values in the Pie chart Legend in QlikView

Show two values in the Pie chart Legend

amithmurali — Tue, 25 Aug 2015 08:03:12 GMT

Hi guys,

In my pie chart. i want to show like this, both %contribution and actual value in the legend.

i am able to show either one at a time not both.

Re: Show two values in the Pie chart Legend

kavita25 — Tue, 25 Aug 2015 09:46:35 GMT

I don't know about the numbers in legend..

but there is another option you can show contribution and revenue in bracket..

for e.g 23.34% (20.7)

Check this workaround...

Hope it helps you

Re: Show two values in the Pie chart Legend

Peter_Cammaert — Tue, 25 Aug 2015 10:16:13 GMT

A few suggestions and workarounds:

Multiexpression in legend of Pie chart

How to show values beside legend in pie chart?

Peter

Re: Show two values in the Pie chart Legend

jagan — Tue, 25 Aug 2015 10:18:39 GMT

Hi,

It is not possible to display like this in Legend, but you can display on the pie chart by adding the expression like below

=Sum(Sales) & '(' & (Num(Sum(Sales) /Sum(TOTAL Sales), '#.00%')) & ')'

and selecting Values on Data Points option for this expression.

Regards,

jagan.

Re: Show two values in the Pie chart Legend

avinashelite — Tue, 25 Aug 2015 10:22:48 GMT

Hi Amit,

As per my knowledge you cannot have legend with both the % and value but you show it in different way in the Legend show the values and with the pie show the %.

This can be easily achieve by adding one more expression with the same calculation , i.e. one with the relative option checked and other with the un-check in this we you can achieve

Re: Show two values in the Pie chart Legend

Tue, 25 Aug 2015 11:04:08 GMT

Show a simple pie chart with a table alongside along it where one column is showing values and second column is showing relative %. Wouldn't it work?

Re: Show two values in the Pie chart Legend

Tue, 25 Aug 2015 11:06:34 GMT

or why not show % in the pie and actual numbers in the legend? or even other way around?

Re: Show two values in the Pie chart Legend

amithmurali — Wed, 26 Aug 2015 07:41:24 GMT

the problem when i show both on the pie chart is that the size of the chart will become very small. i need a big piehcart and numbers in the legend

Re: Show two values in the Pie chart Legend

jagan — Wed, 26 Aug 2015 08:04:57 GMT

Hi Amith,

Check this file hope it helps you. It is not at all possible to display in legend with you values. Instead you can create Straight table beside this pie chart and display the same in that.

Reduce the number display by showing it is thousands, millions etc.

Hope this helps you.

Regards,

Jagan.