Discussion Board for collaboration related to QlikView App Development.
How to change the value 12.3456 to 12.34 using string function
using string fxn? if so just use the left fxn =left(12.3456,5)
better way is the number fxn like below
i.e update your field name instead of the hard coded value
Do you want to round the number (ie to 12.35) or round it down (to 12.34)?
Round up: Ceil(12.3456, 0.01)
Round: Round(12.3456, 0.01)
Round down: Floor(12.3456, 0.01)
I also want to change 12.3456 to 12.35 when 3rd postion after decimal point is >=5.