Discussion board where members can get started with QlikView.
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.
Hope the attached file will help you.
View solution in original post
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):
Do you know how that's possible?
Thanks in advance!
Can you share some sample data and expression you have used.
Try this way.