How to split each Pie Chart section

[JoaquinLavin]

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.

Is there any way to achieve this in QV? Thanks

[rwunderlich]

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. 

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

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

[JoaquinLavin]

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]

You will need to wrap it in Aggr:

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

-Rob