Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Decimal number format in % qliksense

Hi There,

I am trying to apply % for a chart where result is between 0.00 to 0.99 and would like to display as %

When I apply number format it displays as 66.66% or so on. i want it to be 0.66% instead. Can you please suggest the number format

I used ##.00% and few others but dint work.

Thanks,

S

5 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Divide the number by 100 and you will get the expected result.

Regards,

Jagan.

qlikviewwizard
Master II
Master II

Hi,

Please check this. Thank you.

Capture.JPG

Capture.JPG

sinanozdemir
Specialist III
Specialist III

Or you can just add '%' to the number:

Capture.PNG

qlikviewwizard
Master II
Master II

Hi SV,

Did you able to manage to get the solution? Thank you.

aveeeeeee7en
Specialist III
Specialist III

Hi

First Divide your expression by 100

than Go to Number Tab option > Select the Expression on which you want to show

the Percentage Sign (%) and Select Fixed to option and Check Show in Percent (%) option.

See this:

Number Format Option.png

Regards

Av7eN