topic Re: How to show values in percentages in pie chart? in QlikView

How to show values in percentages in pie chart?

Tue, 20 Jan 2015 14:37:41 GMT

Hi,

I have a pie chart with values as below

Product	Sales
Titanic	4565465.56
Berrysold	435346
Cherries	9076876.9
Choclates	6567
Cookies	75657
Total	14159912.46

how can I show the above sales in percentage? can anyone suggest me please?

I have used show in percentage under Number tab but it is not showing correct results? I want to show individual percentage for each product and total percentage

Thanks.

Re: How to show values in percentages in pie chart?

Brett_Bleess — Tue, 20 Jan 2015 14:45:04 GMT

In the Expressions tab of the pie chart properties, when you select the expression, just to the right of that you will see an Enable check box, if you look straight down from there, you will see a Relative check box, checking Relative will automatically convert things to percentage. Hopefully this is what you needed. You can also click the Help button from this dialog and you will get to the context sensitive help for the dialog explaining all of the settings in the dialog.

Regards,

Brett

Re: How to show values in percentages in pie chart?

nirmalraj_kj — Tue, 20 Jan 2015 14:45:39 GMT

PFA, Hope this will helps you

thanks

nirmal

Re: How to show values in percentages in pie chart?

Anonymous — Tue, 20 Jan 2015 14:48:00 GMT

select relative on expression.

Re: How to show values in percentages in pie chart?

Tue, 20 Jan 2015 15:01:38 GMT

Just to sum up what the guys said after I did it. I'm fairly new to QV myself and used this to learn from as well.

in numbers tab, select view as %, under expressions tab select enabled and relative.

Selecting Relative associates the numbers to one another, otherwise it will deliver the number as a percent as it is delivered if it already a % in other words.

Hope it helps and thanks everyone for the contributions, it was a fun exercise.

Jayson

Re: How to show values in percentages in pie chart?

NickHoff — Tue, 20 Jan 2015 15:11:57 GMT

Another way instead of relative value is to use the expression =SUM(Sales)/SUM(Total Sales)

Re: How to show values in percentages in pie chart?

Anonymous — Tue, 20 Jan 2015 18:07:37 GMT

Check Relative Checkbox in Expression tab

Re: How to show values in percentages in pie chart?

jonasheisterkam — Tue, 20 Jan 2015 18:22:36 GMT

if you want display mor informations. Relativ, Absolut and other you can add more expressions, only the first will create the pie all other creates addition values at the pie.