topic Pie with 2 dimensions in QlikView

Pie with 2 dimensions

Tue, 17 Nov 2009 17:58:20 GMT

Hello everybody,

I have been asked to do a pie chart based on two dimensions (let us say Zone and Item) combined together. This means, they don't want to see a two level pie, as like QV will do in this case, but a plain pie with the two dimensions combined together. Like this:

ZONE1 - ITEM1 is a slice
ZONE1 - ITEM2 is another slice
ZONE2 - ITEM1 is a third slice, and so on...

In other word, this would be the same we would get in the external crown of a two-dimension pie, but without the internal sub-pie.

The solution should be a calculated dimension like that:

Zone & "-" & Item

But this seems to be very hard to compute for QV and, eventually, I get an out of memory or internally failed drawing error, despite the numerosity of the fields is rather low (the total number of combination is about 20).
Using a linear table instead, I get the result without errors, after a very long computing time.

Any workaround suggested?

Thanks

Paolo

Pie with 2 dimensions

prieper — Fri, 20 Nov 2009 03:22:10 GMT

Have you tried a stacked bar-chart - eventually in vertical order?

HTH
Peter

Pie with 2 dimensions

Fri, 20 Nov 2009 04:16:55 GMT

Yes. But they want the pie.....

So, I managed to give them their pie with concatenated dimensions, but removing any other object and data... and still it takes minutes to draw. Definitely it's a critical task for QV.

Thanks

Paolo

Pie with 2 dimensions

prieper — Fri, 20 Nov 2009 04:27:47 GMT

Not sure, if I got your problem correct. Can you concatenate in the script probably? Have attached a small sample.

Peter

Pie with 2 dimensions

Sat, 21 Nov 2009 03:02:03 GMT

Yes, I can, and I agree this is the best solution. I was trying to avoid it because, besides the example, I have a number of different combinations to consider, but I will do this way.

Thank you very much again

Paolo