topic Re: Format as a percentage in QlikView

Format as a percentage

fanninam — Wed, 25 Nov 2020 16:16:04 GMT

Good Afternoon,

I'm trying to get the following to format as a percentage. It is not working. The number format is still showing as .0080831034482759 even when I use the script below:

='Sustain'&sum(TOTAL{$<Category={'Sustain'}>} [Committed Amount]) / (Budget),'#,##0%'

Re: Format as a percentage

sunny_talwar — Thu, 02 Feb 2017 03:22:23 GMT

I think you forgot the Num() function.... Try this:

='Sustain' & Num(Sum(TOTAL {$<Category={'Sustain'}>} [Committed Amount]) / (Budget),'#,##0%')

Re: Format as a percentage

vardhancse — Thu, 02 Feb 2017 04:10:49 GMT

can try this once:

='Sustain'& NUM(sum(TOTAL{$<Category={'Sustain'}>} [Committed Amount]) / (Budget),'#0.00%')

Re: Format as a percentage

Thu, 02 Feb 2017 04:27:34 GMT

='Sustain'& NUM(sum(TOTAL{$<Category={'Sustain'}>} [Committed Amount]) / (Budget),'#0.00%')