Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: How to have integer format in a TEXT Object

num(0.03892852, '0.##' )

Not applicable

Re: How to have integer format in a TEXT Object

Thank you, I was close enough!

Community Browser