Fill the Pie Chart

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

I have an expression that has Count as below:

Num(Count(if(Type='Act' and Val='Match' and Stats='Yes', Entry))) / Num(Count(if(Type='Act' and Val='Match', Entry))'##.0%')

This gives me a number in % format which is what I want if I put in a text box or a Guage Chart. I want to use this expression in a Pie Chart but the issue in creating a Pie chart with this expression is, it only gives me one Big Pie with the % value. For example, if the expression gives 65% in a text box, when I use the same expression in Pie Chart as Dimension and Expression, it gives me a Full Pie with 65%. I want 65% and the remaining 35% as two different Pies in the chart. How can I get that. Any help would be really appreciated.

Re: Fill the Pie Chart

dplr-rn — Mon, 24 Sep 2018 18:30:44 GMT

Create a pie chart with a calculated dimension

=ValueList('Your_Title','Others')

expression

=IF( ValueList('Your_Title','Others')='Your_Title',

[Your expression],

1- [Your expression]

)

Re: Fill the Pie Chart

qlikwiz123 — Mon, 24 Sep 2018 20:27:32 GMT

Thank you so much Dilip! Nice Workaround

topic Re: Fill the Pie Chart in QlikView

Fill the Pie Chart

Re: Fill the Pie Chart

Re: Fill the Pie Chart