topic Re: How to create pie chart with two expressions in QlikView

How to create pie chart with two expressions

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I would like to create a pie chart which will give me the ratio of two sums:

sum(xxx) (answer of sum is 8.000.000.

sum(xxx) (answer of sum is 2.000.000.

So I expect a pie chart which will give me a piece of 80% and a piece of 20%.

Now I get two times a piece of 100% when I choose relative and have set two expressions which I have devided by the total of sums (10.000.000).

I hope anybody can help me.

Gr. Pascal

krishnacbe — Wed, 01 Nov 2017 19:19:50 GMT

Hi,

Hope the attached file will help you.

Anonymous — Wed, 01 Nov 2017 20:12:27 GMT

Hi Krishnapriya Arumugam,

Thanks for the solution.

Last but not least, I get a result of 88% against 14%. (above 100%) (??)

I expect the following ratio (my previous message was fictional):

86,4734%

13,52,66%

Do you know how that's possible?

Thanks in advance!

Gr. Pascal

krishnacbe — Wed, 01 Nov 2017 20:17:27 GMT

Hi,

Can you share some sample data and expression you have used.

Anonymous — Wed, 01 Nov 2017 20:45:50 GMT

Try this way.

Dan36 — Fri, 05 Aug 2022 00:20:53 GMT

Can someone pls share the answer not in .qvw