Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Naps_230
Creator
Creator

how to convert large value into percentage in expression.

Hi,

I have value like 0.00014436548660934. I want to value like 14.43 in expression.

jaso

4 Replies
hirenjadiya
Partner - Contributor III
Partner - Contributor III

You can use Num() function for this.

Try, Num(0.00014436548660934, '#,##0.0%')

harishkumarg
Creator III
Creator III

Can you explain in detail or share some sample data set.

Regards

Harish

stabben23
Partner - Master
Partner - Master

maybe expression *100000?

Anonymous
Not applicable

If these values are ready and you just want to format, it can be done like this:

        

     value * 100000 & '%'

percent.JPG