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.

[Anonymous]

Hi

Please post sample data in excel sheet.

[kaushiknsolanki]

Here is the solution.

Regards,

Kaushik Solanki

[#4]

Hey,

I have attached the excel sheet

[#5]

Hey,

Thanks for the response. Unfortunately, I am running the personal edition of QlikView and hence cannot open the file. Can you please advice what to do?

Thanks

[Anonymous]

Hi,

Go to the Expression Tab. Under the Expression you created, there is + sign , expand this and you will see a Pie Popout option. Select this option and enter an expression such as len(your dimension) > 0 or sum(your expression) > 0.

Alternatively, just enter 1 in the popout option

[Anil_Babu_Samineni]

I am just helping from Kaushik example for ref

Is this you are expecting? And your example is in image, Can you post same data in excel, May be to achieve this

[#8]

Yes, This is what I am looking for. And the pie chart should change with relevant Region selection.

[#9]

I appreciate your help, I am just a beginner. I dont know what expressions to use , itried many but failed.

[#10]

also , how can I attach excel sheet here in the discussion? Please help me.