Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP
MVP

Re: Decimal number format in % qliksense

Hi,

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

Regards,

Jagan.

Arjunarao
Honored Contributor II

Re: Decimal number format in % qliksense

Hi,

Please check this. Thank you.

Capture.JPG

Capture.JPG

sinanozdemir
Valued Contributor III

Re: Decimal number format in % qliksense

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

Capture.PNG

Arjunarao
Honored Contributor II

Re: Decimal number format in % qliksense

Hi SV,

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

aveeeeeee7en
Valued Contributor III

Re: Decimal number format in % qliksense

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

Community Browser