Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

How to create pie chart with two expressions

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi,

Hope the attached file will help you.

View solution in original post

4 Replies
Highlighted
Partner
Partner

Hi,

Hope the attached file will help you.

View solution in original post

Highlighted
Contributor III
Contributor III

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

Highlighted
Partner
Partner

Hi,

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

Highlighted
Specialist II
Specialist II

Try this way.