Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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