topic Re: How to split each Pie Chart section in QlikView

How to split each Pie Chart section

JoaquinLavin — Wed, 23 Nov 2022 12:56:27 GMT

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

Re: How to split each Pie Chart section

rwunderlich — Thu, 24 Nov 2022 03:10:05 GMT

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

Re: How to split each Pie Chart section

JoaquinLavin — Thu, 24 Nov 2022 12:17:37 GMT

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!

Re: How to split each Pie Chart section

rwunderlich — Thu, 24 Nov 2022 13:36:10 GMT

You will need to wrap it in Aggr:

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

-Rob