Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
rofa84
New 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
MVP & Luminary
MVP & Luminary

Re: Converting solid number to percentage.

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

- Marcus

View solution in original post

1 Reply
MVP & Luminary
MVP & Luminary

Re: Converting solid number to percentage.

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

- Marcus

View solution in original post