Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lingzhouwu
New Contributor

Format numbers as percentage

Hi all,

I was wondering how I could show my measure field as a percentage.

E.g. if I had a value of 3, I would want to format it through 'Number formatting' to show as 3%.

I can't just add a '%' to the end of the 'Format Pattern' as it would show as 300%.

Help is greatly appreciated.

Tags (1)
3 Replies
sumanta12
Contributor II

Re: Format numbers as percentage

Hi Lingzou,

First divide measure field by 100 (measure/100) then format it through 'Number formatting' to show as 3%.

lingzhouwu
New Contributor

Re: Format numbers as percentage

Hi Sumanta,

Sorry I should have mentioned that while that solution would typically work, I cannot use it in this context.

I am using an extension to create a radar graph but the axis only goes as low as 0.1 (I have no idea why).

A lot of my data have values lower than 0.1 so currently my radar graph currently looks very empty except for a bunch of lines bunched up in the centre. I need my data to actually have value over 0.1.

Thus what I want to do is: value*100 and add a % symbol to the end.

E.g. Turn 0.009 into 0.9 and show it as 0.9%.  

laurischarf
Contributor II

Re: Format numbers as percentage

Try this:

num([number], '##0%')

You can also add a comma:

num([number], '#,##0%')

Community Browser