Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
lingzhouwu
Contributor
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.

6 Replies
sumanta12
Creator II
Creator II

Hi Lingzou,

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

lingzhouwu
Contributor
Contributor
Author

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
Specialist
Specialist

Try this:

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

You can also add a comma:

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

qlikdelqbz
Contributor III
Contributor III

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
Contributor III
Contributor III

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_
Contributor II
Contributor II

Try

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

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

Capture.JPG