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
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
rofa84
Contributor II
Contributor II

Converting solid number to percentage.

Hi, 

I'm very new to Qlick Sense and I'm having trouble converting  number 22.09 into 22.09%. I imported the number directly from an excel file. I used both Customize and Number for formatting option. 

I've tried "#.##0,00% or #,##0.00%" but it converted to 2209%. Please help me

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

Just use: num(22.09 / 100, '0.00%')

- Marcus

View solution in original post

1 Reply
marcus_sommer
MVP & Luminary
MVP & Luminary

Just use: num(22.09 / 100, '0.00%')

- Marcus

View solution in original post