Discussion board where members can get started with QlikView.
How would I limit number of decimal to only 2 in the load statement?
My numbers come with different number of decimals.
if it's a whole number - 259.00000 (number of zeros vary) - I want this to be 259
if it's not - 485.9994 , 323.25, 101.444 - I want this to be 485.99, 323.25, 101.44
May be using Num() function
Num(NumberField, '#,##0.00') as NumberField
View solution in original post
Will this make 259.00 or 259? I would need the latter.
you can also try it in front end.
you can override as you can...
Thanks Surendra. I am aware of this option. However, I need it to be on LOAD