topic Re: Advanced Chart Help in QlikView

Advanced Chart Help

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I need to achieve this chart...

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.

Re: Advanced Chart Help

Anonymous — Tue, 23 May 2017 12:27:50 GMT

Please post sample data in excel sheet.

Re: Advanced Chart Help

kaushiknsolanki — Tue, 23 May 2017 12:32:09 GMT

Here is the solution.

Regards,

Kaushik Solanki

Re: Advanced Chart Help

Tue, 23 May 2017 12:41:15 GMT

Hey,

I have attached the excel sheet

Re: Advanced Chart Help

Tue, 23 May 2017 12:43:00 GMT

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

Re: Advanced Chart Help

Anonymous — Wed, 24 May 2017 03:26:53 GMT

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

Re: Advanced Chart Help

Anil_Babu_Samineni — Wed, 24 May 2017 04:45:31 GMT

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

Re: Advanced Chart Help

Wed, 24 May 2017 06:39:02 GMT

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

Re: Advanced Chart Help

Wed, 24 May 2017 06:40:35 GMT

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

Re: Advanced Chart Help

Wed, 24 May 2017 06:41:22 GMT

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

Re: Advanced Chart Help

Wed, 24 May 2017 07:44:05 GMT

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

Re: Advanced Chart Help

prma7799 — Wed, 24 May 2017 07:47:40 GMT

Please check this

Re: Advanced Chart Help

Wed, 24 May 2017 08:17:08 GMT

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).

Re: Advanced Chart Help

Wed, 24 May 2017 08:20:53 GMT

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

Re: Advanced Chart Help

Wed, 24 May 2017 08:44:19 GMT

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

Re: Advanced Chart Help

prma7799 — Wed, 24 May 2017 09:12:59 GMT

Don' use Dimension

Use Expression

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

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

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

Re: Advanced Chart Help

Wed, 24 May 2017 09:22:13 GMT

Hey

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

Re: Advanced Chart Help

Wed, 24 May 2017 09:23:07 GMT

Correct answer.

Re: Advanced Chart Help

Wed, 24 May 2017 09:24:16 GMT

Thank you all for the help.