Discussion Board for collaboration on QlikView Scripting.
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.
num(0.03892852, '0.##' )
Thank you, I was close enough!