Format numbers as percentage

[Anonymous]

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.

[sumanta12]

Hi Lingzou,

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

[Anonymous]

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%.  

[Lauri]

Try this:

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

You can also add a comma:

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

[qlikdelqbz]

It seems like that the "num(value,'#,#0.0%')" formula works perfectly in table, but not in graph (at least does not work for me in scatter plot). Anyone has good solution? Appreciated!

[qlikdelqbz]

It seems like that the "num(value,'#,#0.0%')" formula works perfectly in table, but not in graph (at least does not work for me in scatter plot). Anyone has good solution? Appreciated!

[Marius_]

Try

num(Round([Field],0.0001),'#0.00')

and set   Number-tab as "Show in Percent(%)"

[jannis_qlik]

I faced the same issue today. This worked for me:

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

If you keep two whitespaces behind the % qliksense won't change the value.