topic Pie Chart within a pie chart in QlikView

Pie Chart within a pie chart

cmccafferty — Thu, 17 Mar 2011 11:40:42 GMT

Hi people, I need some help with Pie Charts.

I want to show total revenue of a concert, split by booking, then of each booking I want to show what proportion of the booking revenue is profit, so the inner circle will be split by booking reference, and each segment will be split out to show costs and profit... Attached is a drawing of what I have in mind... Is this feasible??

Pie Chart within a pie chart

Thu, 17 Mar 2011 11:47:08 GMT

Just add 2 dimensions in your Pie chart, QlikView should do this automatically.

Pie Chart within a pie chart

cmccafferty — Thu, 17 Mar 2011 12:17:56 GMT

Yes, tried that... but it didnt behave properly, need to know how to reference each table properly to get it displayed right.

Tables are: Booking Ref, Costs, Revenue

Pie Chart within a pie chart

johnw — Fri, 18 Mar 2011 00:13:16 GMT

So your table structure for the data in your picture is this?

Booking Ref:
Booking Ref
ABC 1
ABC 2

Revenue:
Booking Ref, Revenue
ABC 1, 1000
ABC 2, 500

Costs:
Booking Ref, Cost Name, Cost
ABC 1, Cost 1, 300
ABC 1, Cost 2, 200
ABC 1, Cost 3, 100
ABC 1, Cost 4, 150
ABC 2, Cost 1, 350

One way, though I don't think you'll like it, is to put the profit on the costs table. If one of your "costs" was the profit, then it would add up correctly to the revenue. Then just use a background color expression or something to color profit differently from costs. Mind you, I tried to do this quickly, and couldn't get the colors to work, and I'm not sure how to put the legends in the pie slices. I never use pie charts, so they're not really my area of expertise.