Pie Chart Query

[Adam12]

Hi There,

I'm still learning when it comes to QlikView and just had a question about a pie chart I wanted to create.

I have a SQL DB table set up like the example below:

Essentially I just want a pie chart of where the reasons are Y and where you filter by the quarter name dimension, the results adjust accordingly. Would I add the reasons as separate dimensions and then one expression accounting for all of them? 

Any help or insight would be greatly appreciated.

Many thanks

[jwjackso · Accepted solution]

I would use the Crosstable command in the data load script to change the table to Quarter Name, Organization, Reason.  This would be more flexible with your chart, the dimension just becomes Reason.

[Adam12]

Thank you, that worked a treat. I've managed to get the results I wanted. Thanks for your help