Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
JoaquinLavin
Contributor
Contributor

How to split each Pie Chart section

Hello everyone, 

I'm working with a Pie Chart displaying how many Male and Female applicants we have had in our selection processes, and I want to split each gender into "selected" and "not selected", but I can't seem to find a way to achieve this.

I'm attaching a picture of this same idea but made in Power BI.

JoaquinLavin_0-1669208148763.png

Is there any way to achieve this in QV? Thanks

Labels (2)
3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

For QV you can make a calculated dimension combining the gender and the selected status like:

=Sex & ' ' & Selected

Then you'll need to play with the display properties and you can create something like this picture. Example QVW attached. 

 

rwunderlich_0-1669259253872.png

 

Thank you for letting me make a pie on the Thanksgiving holiday. 

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

JoaquinLavin
Contributor
Contributor
Author

Thanks Rwunderlich, I wasn't aware of that option of combining fields 🙂

 

I forgot to add in my original question, I need to display only one of all the possible Status, using "=only({<Status={'Job Offer'}>}(Gender&' '&Status))" as a calculated dimension, but I'm getting an "Error in calculated dimension" message. Any insight on this? Thanks!

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You will need to wrap it in Aggr:

=Aggr(only({<Status={'Job Offer'}>}(Gender&' '&Status)), Gender, Status)

-Rob