Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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

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

- Marcus

View solution in original post

1 Reply
marcus_sommer

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

- Marcus