Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
amithmurali
Partner - Creator II
Partner - Creator II

Show two values in the Pie chart Legend

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.

scn.jpg

8 Replies
kavita25
Partner - Specialist
Partner - Specialist

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)

OR

Check this workaround...

Hope it helps you

Peter_Cammaert
Partner - Champion III
Partner - Champion III

jagan
Luminary Alumni
Luminary Alumni

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.

avinashelite

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 

Not applicable

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?

Not applicable

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

amithmurali
Partner - Creator II
Partner - Creator II
Author

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

jagan
Luminary Alumni
Luminary Alumni

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.