Fill the Pie Chart

[qlikwiz123]

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.

[dplr-rn · Accepted solution]

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]

) 

[qlikwiz123]

Thank you so much Dilip! Nice Workaround