Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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')