Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview 11 for developers - Pie chart formatting

How do I add the percentages ?

Untitled.jpg

13 Replies
barryharmsen
Luminary Alumni
Luminary Alumni

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
Support
Support

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
Not applicable
Author

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
Master III
Master III

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?

May you live in interesting times!