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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Formatting numbers in a text box

Hello

I have a calculation insetrted a bit of active text in a text object .

How do I format these numbers to display as a % with two decimals as currently the result of the calculation shows as an unformatted number with decimals up to anbotu 10 places?

Jon



3 Replies
Not applicable
Author

Try some like: =num( pi( ) , '0,00' )&'%'
Not applicable
Author

hI

Num(sum [value]),'# ##0.00 %')

NO NEED TO DEVIDE BY 100

THANKS

michale

jvishnuram
Partner - Creator III
Partner - Creator III

Hi Jon,

First decide your output format using any of the chart properties number tab and copy that formatting come to text oject and paste like this,

Num(Expr1,'Copied Format')

VJ