Solved: Show the percentage in a pie chart and values of t... - Qlik Community

Pragya · ‎2022-02-21

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 · ‎2022-02-21

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

View solution in original post

vikasmahajan · ‎2022-02-21

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

View solution in original post

vikasmahajan · ‎2022-02-21

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Pragya · ‎2022-02-21

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

vikasmahajan · ‎2022-02-21

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2022-02-24

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

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Pragya · ‎2022-02-27

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.

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

Chart