topic Pie Chart Query in QlikView

Pie Chart Query

Adam12 — Wed, 19 Aug 2020 16:29:50 GMT

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

Re: Pie Chart Query

jwjackso — Wed, 19 Aug 2020 17:09:54 GMT

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.

Re: Pie Chart Query

Adam12 — Fri, 21 Aug 2020 12:44:38 GMT

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