how to create special pie chart?

[#1]

I have following data:
Category PartA PartB PartC
A 5 3 2
A 10 4 1
A 3 6 11
A 2 4 8
B 3 0 2
B 5 1 4
C 6 4 2
C 2 0 1

if I select in QlikView sheet (in object ListBox LB01) value "A"
I want create pie chart which display ratio of PartA, PartB and PartC on summary data of "A".
In this case it will be pie chart consists of three parts - first slice will have value of 20 (result of PartA values: 5+10+3+2)
second will have value of 17 (3+4+6+4) and third slice will be value of 22 (2+1+11+8).
Whole of pie will be value of 59 (result of all PartA values, PartB values and PartC values).

Or if I select value "B", pie chart will be three parts. First=8 (3+5), second=1 (0+1), third=6 (2+4)

How can I create that pie chart?

thanks

[#2]

Maybe is same bug.....try to build again!!!!

Never happen that with me!!!!!

[montubhardwaj]

Hi Ronald,

Perhaps it is late now and you would have resolved it. I just wanted to update this post

To have the other expressions as pop-up, we can do little "work around" here.

For example, suppose you have 3 expressions say (sales,profit and margin). By default, QV8 will pop-up only for 1st expression.In order to make other also as pop-up, do the following"

hardcode the expression with the name as you want to see in the pop-up. For example, if you want to see pop-up as "Profit= <value>", then hardcode it as

='Profit=' & Sum(Profit)

follow the similar technique for other expressions also.

Note: Make sure you check "Text as Po-Up".

Hope that was helpful.

[Anonymous]

That didn't help to me. Where did you change that ='Profit=' & Sum(Profit) ? I changed that in Definition and the Label of the expressions without sucess. Do you have an exemple?