topic Re: Percentage formatting in QlikView

Percentage formatting

Wed, 21 Nov 2012 08:26:32 GMT

Hello everybody,

I have a question about percentage formatting in a gauge chart.

I have this calculation:

=sum({$<Dato.aar={$(=$(vCurrentYear))}>} Beløb) / sum({$<Dato.aar={$(=$(vPreviousYear))}>} Beløb)

The calculation is fine enough, but when i have for an example: 15899 / 8 - It will give me 1986,15 or something. But when i want my gauge chart to show numbers in percentage it makes my number to 198.615% instead

I know its because when i set my number to percentage it automatically multiplies with 100.

But how can i do so it wont affect my calculation ?

Hope you know what i mean.

Ived also tried this:

=num(sum({$<Dato.aar={$(=$(vCurrentYear))}>} Beløb) / sum({$<Dato.aar={$(=$(vPreviousYear))}>} Beløb), '#.##0%')

Thanks in advanced

Re: Percentage formatting

Wed, 21 Nov 2012 10:15:46 GMT

Nevermind, i fixed it! I was just not thinking ;D

Re: Percentage formatting

Thu, 26 Sep 2013 13:22:22 GMT

hi - I am having the same issue

how did you fix it?

Re: Percentage formatting

Thu, 26 Sep 2013 14:25:48 GMT

put -1 behind the num function

In presentation, text in chart - add expression

example:

=num(sum({$<Year={$(=$(vCurrentYear))}>} BuyPriceRealized) / sum({$<Year={$(=$(vPreviousYear))}>} BuyPriceRealized) -1 , '#.##0%')