topic Re: Qlikview 11 for developers - Pie chart formatting in QlikView

Qlikview 11 for developers - Pie chart formatting

Fri, 18 Apr 2014 01:30:24 GMT

How do I add the percentages ?

Re: Qlikview 11 for developers - Pie chart formatting

Fri, 18 Apr 2014 01:50:44 GMT

1. To get the percentages instead of actual values, check 'Relative' on the Expression tab in the properties.

2. To get the percentages to show up on the graph, check 'Values on Data Points' on the Expression tab in the properties.

Hope that helps!

Re: Qlikview 11 for developers - Pie chart formatting

Fri, 18 Apr 2014 02:01:50 GMT

1.Go to Expression Tab

2. On the display Options check the 'Value On data points'

Then you will get percentages

Re: Qlikview 11 for developers - Pie chart formatting

Fri, 18 Apr 2014 03:13:13 GMT

select pie chart - properties - check on 'Relative' and 'value on data points' check boxes

Re: Qlikview 11 for developers - Pie chart formatting

Fri, 18 Apr 2014 17:27:15 GMT

Thanks venu. But, how do I get the percentages as shown ? I tried setting percentage in Number tab and I get a different result -

Re: Qlikview 11 for developers - Pie chart formatting

santharubban — Fri, 18 Apr 2014 17:30:15 GMT

see the pic

Re: Qlikview 11 for developers - Pie chart formatting

its_anandrjs — Fri, 18 Apr 2014 17:47:58 GMT

Use num function for the expression

Num( YourExpression,' #,##0.00 ' )

Re: Qlikview 11 for developers - Pie chart formatting

Fri, 18 Apr 2014 17:59:21 GMT

you need to check on 'relative' check box in properties - expressions tab

Re: Qlikview 11 for developers - Pie chart formatting

oknotsen — Fri, 18 Apr 2014 18:01:27 GMT

On the expressions tab, select the expression.

In the mid-middle of the tab,right above "display options", you will find "Relative". This will turn the results of the expression into a percentage of the total of the expression. This will automatically turn the number formatting into showing the result as a percentage and all answers will total to 100%.

Re: Qlikview 11 for developers - Pie chart formatting

Fri, 18 Apr 2014 20:08:57 GMT

Got it ! But the percent % sign is missing. How do I get that ? In number tab, I chose Number with precision = 4, show in percent.

Re: Qlikview 11 for developers - Pie chart formatting

barryharmsen — Wed, 23 Apr 2014 19:23:13 GMT

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.

Re: Qlikview 11 for developers - Pie chart formatting

Joseph_Musekura — Wed, 23 Apr 2014 19:35:44 GMT

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

Re: Qlikview 11 for developers - Pie chart formatting

Anonymous — Fri, 04 Sep 2015 17:16:16 GMT

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ł

Re: Qlikview 11 for developers - Pie chart formatting

oknotsen — Tue, 08 Sep 2015 15:07:14 GMT

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?