Qlikview 11 for developers - Pie chart formatting

[#1]

How do I add the percentages ?

[barryharmsen]

This has actually changed in later versions of QlikView (we wrote against QV11 SR1) and doesn't work anymore. Will follow up with the correct solution later.

[Joseph_Musekura · Accepted solution]

Dear John,

There is a known bug that was found in some version of
Qlikview (example version11.20SR3). In 11.20SR3, % on Pie chart is not
displayed. This was corrected from QlikView desktop v 11.20SR4. If you are
using such version you will need to update to latest version ex 11.20SR5 to be
able to view % in Pie chart.

/jo

[Anonymous]

Hi,

I've got some expression that works the same as Relative option, but it gives you more flexibility to add some additional characters and much more to your expression on a chart:

=num( (sum [Your_Measure])*100 / sum(TOTAL [Your_Measure]) ), '#.##0,00' ) & ' %'

1) num function lets you format the number

2) TOTAL lets you sum across all your dimensions up (not only one dimension)

3) & joins different types of data (here: numbers and string)

4) ' %' simply adds % in the end of you calculation

I know it's really simple, but sometimes when you begin (as me) with QV it might be helpful.

Best regards,

Michał

[oknotsen]

Better: Make the percentage part of the format :

=num( (sum [Your_Measure]) / sum(TOTAL [Your_Measure]) ), '#.##0,00%' )

Anyway,

Why are we kicking a 1 year old topic?