topic Re: Using two dimensions in a Pizza Chart in QlikView

Using two dimensions in a Pizza Chart

Fri, 11 Sep 2015 17:49:33 GMT

Hello,

I am creating a pizza chart which displays data from two different dimensions of different tables, and i would like to group the data in the same chart, and not one dimension inside the other as displayed in the image below:

Please, is it possible to use two different expressions and display in one single pizza chart ?

Hope hear from you soon.

Regards!

Re: Using two dimensions in a Pizza Chart

Anonymous — Fri, 11 Sep 2015 17:53:32 GMT

hi rodrigo,

please post sample data.

regards

neetha

Re: Using two dimensions in a Pizza Chart

Fri, 11 Sep 2015 17:55:54 GMT

Hi Neetha,

What did you mean?

Could you please clarify?

Regards,

Rodrigo

Re: Using two dimensions in a Pizza Chart

Anonymous — Fri, 11 Sep 2015 18:13:19 GMT

hi rodrigo,

see:

Re: Create inner and outer pie chart

Pie chart is not a very useful chart, especially when you have more than one dimension.. maybe use a bar chart or a pivot table instead rather than by creating such dysfunctional charts.

Re: Using two dimensions in a Pizza Chart

dgreenberg — Fri, 11 Sep 2015 19:00:00 GMT

I agree that the pie chart may not be very useful but you may be able to accomplish what you want by overlaying a 2nd chart with the same scale and different expression making sure it's transparent except the values.

I have done this with gauge charts and it can be pretty cool not sure about a pie chart.