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

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

How to have integer format in a TEXT Object

Hello,

I have an expression in a text box which results\bring me a number. This number is in the following format XX.YYYYYYYY

I would like to change the format, in the text object so that I will only see 2 characters after the Dot (Decimal point)

For example, if the result of the expression is 0.03892852 I would like to present in the text object only 0.03

Again, I know there is a property called Number in a chart object but It does not exist in text box.

In addition, I tried using the Ceil option but it change such a result 0.03892852  to 1 which is unwelcome.

Any Idea, workaround which be appreciated.

Nir

2 Replies
Anonymous
Not applicable
Author

num(0.03892852, '0.##' )

Not applicable
Author

Thank you, I was close enough!