Advanced Chart Help

[#1]

Hello,

I need to achieve this chart...

jagan‌Qlik Community MVP‌

Red= Red/(Red+Green+Yellow), Green= Green/(Red+Green+Yellow), Yellow=YellowR/(Red+Green+Yellow)

with the data below

When none/all of the regions are selected the chart should display the calculated sum of all columns and a region is selected, the sum of corresponding column values is to be shown.

Can someone please help me out. I am quite new to QlikView and BI.

Thanks in advance.

PS: I don't even know how to frame this question, sorry.

[#2]

Also Why are my replies getting more than an hour (sometimes two) to get approved?

[prma7799]

Please check this

[#4]

Thanks for the response, I think this has something to do with the styling. I am looking for help as to what should be the dimension and the expression(s).

[#5]

Hello Kaushik,

The solution you send me yesterday seems to be the right one(Courtesy to the pie chart image posted  Anil babu ). However I couldn;t open the document . I will be grateful if you could help me out.

Thanks

[#6]

I cannot open the document as I am running qlikview personal edition. Can you advise what should be the dimension and what expression to use.

Thanks

[prma7799 · Accepted solution]

Don' use Dimension

Use Expression

Sum(Red)/Sum(Red +Yellow+Green)

Sum(Yellow)/Sum(Red +Yellow+Green)

Sum(Green)/Sum(Red +Yellow+Green)

[#8]

Hey

Thanks mate . Exactly. I have marked it as the correct answer.

[#9]

Correct answer.

[#10]

Thank you all for the help.