Show the percentage in a pie chart and values of the pie chart also

[Pragya]

Hi all, 

I have a pie chart. I want to create a button for it where

-          if I click on it and percentage of different sections of pie chart comes

-          if i click on second button than values of pie chart comes. 

I know that in Qlik cloud , when i go to presentation, i click on value label which should be custom and if i click on share i see percentage and if i click on value i see values in number. But i dont know how to code this in the button.

Could someone help please ?

Thanks 

Pragya

[vikasmahajan · Accepted solution]

Hi ,

PFA sample application which demonstrate % Value & Value both in chart  following setting you need to apply for value & Share as %.

Hope this helps

Vikas

[Pragya]

Could you please suggest step wise what I need to do. Sorry I am a beginner.

[vikasmahajan · Accepted solution]

Steps to create a pie chart :

Create % Total Pie chart :

go to load editor  paste script :

YTD_MTD_Flags:
Load * Inline [
SalesDate , CustomerName, Sales_Value
1/4/2021,PPP,200
5/5/2021,QQQ,300
6/6/2021,RRR,500
7/7/2021,AAA,100
8/8/2021,BBB,200
9/9/2021,CCC,300
10/10/2021,DDD,400
];

Load Script & save application  as Barchart demo

2. edit sheet

3 drag pie chart 

4  dimension Customername

5 measure : Sum(Sales_Value)

6this will create % pie chart  : 

7 Right click  chart save it to master item

8 delete %pie chart we already save it into master item

9 create another pie chart for value 

10 drag pie chart 

11  dimension Customername

12  measure : Sum(Sales_Value)

13  select Value Labels : Select - Value this will show you value instead of % in pie char

14. save this as value Chart 

15 add to master item 

16 delete value chart

17 add container 

18 add % chart 

19 add Value chart 

Hope this help you

Vikas

[vikasmahajan]

if you done with could you please close solution with marking accept solution ?

Vikas

[Pragya]

Hi Vivek, 

Thankyou so much for following up on this. I was sick and couldnt login for few days. I will have a look at it today and let you know. 

Really appreciate your help.