Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator III
Creator III

Fill the Pie Chart

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.

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

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]

View solution in original post

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

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
Creator III
Creator III
Author

Thank you so much Dilip! Nice Workaround