Solved: Transforming integer to percentage in pie chart - Qlik Community

Report Inappropriate Content · ‎2015-11-26

Hello everyone,

I am trying to convert number to percentage in a pie chart, which i have 3 expressions:

sum([Baby Boomers])

sum(X)

sum(Y)

In the Expression tab, when i select the relative box, all results are 100%:

If i unselect the relative box and set the percentage in the Number tab, the results are wrong:

Below is the chart with the original numbers:

How can i convert the numbers above to the correct percentage?

Regards

MarcoWedel · ‎2015-11-26

Hi,

one solution could be either:

(Rangesum() instead of just adding the fields for proper null-value results)

or (without changing your data model) using a calculated dimension and a single expression to be able to use the "relative" option for expressions like already suggested by swuehl‌ (although I think his CrossTable solution results in the better data model for your requirements):

hope this helps

regards

Marco

View solution in original post

Mark_Little · ‎2015-11-26

Hi

I would look at something like

sum([Baby Boomers]) / (sum([Baby Boomers]) + sum(X) + sum(Y))

sum(X) / (sum([Baby Boomers]) + sum(X) + sum(Y))

sum(Y) / (sum([Baby Boomers]) + sum(X) + sum(Y))

Mark

buzzy996 · ‎2015-11-26

can u share sample .qvw?

Report Inappropriate Content · ‎2015-11-26

Thanks for your response Mark.

I have other pie chart, with different expressions:

sum({<[Generations]={"Regional"}>}[Baby Boomers])

sum({<[Generations]={"Regional"}>}X)

sum({<[Generations]={"Regional"}>}Y)

I am just selecting values from Regional for each Generation.

How it should be the expression to calculate the percentage in that case?

Best regards,

Marcio_Campestrini · ‎2015-11-26

Rodrigo

You can calculate it or simply mark the option "Relative" in expressions tab.

Márcio Rodrigo Campestrini

Report Inappropriate Content · ‎2015-11-26

Hi Márcio,

When i select the option Relative in expressions tab, the result is wrong, all values is 100% as i mentioned before:

settu_periasamy · ‎2015-11-26

Hi Rodrigo,

May be try this expression..

sum({<[Generations]={"Regional"}>}[Baby Boomers])/sum({<[Generations]={"Regional"}>} TOTAL [Baby Boomers])

sum({<[Generations]={"Regional"}>}X)/sum({<[Generations]={"Regional"}>} TOTAL X)

sum({<[Generations]={"Regional"}>}Y)/sum({<[Generations]={"Regional"}>} TOTAL Y)

And, set the percentage in the Number tab..

Report Inappropriate Content · ‎2015-11-26

Hi settu_periasamy,

Unfortunately the expression you suggested didn´t work.

It displayed all values with 100%:

swuehl · ‎2015-11-26

Look at the alternative solution I suggested here:

Using multiple fields in a pie chart

i.e. use a dimension with one expression instead of three expression with no dimension. Then you can simply check the 'relative' option.

settu_periasamy · ‎2015-11-26

Hi Rodrigo,

Just to confirm,

Did you uncheck relative and set "Fixed to" and "Show in percentage" in Number Tab.

Or,

=Num(YourExpression,'#.##0%') -> Expression Default in Number Tab