I set this format in a field in my script: Num(FIELD_VALUE, '#,##0')
If FIELD_VALUE is 8.00 qlikview correctly formats it to 8.
But if FIELD_VALUE is 1, the format becomes 1.0000 which is wrong.
The value should remain 1.
Any idea how to overcome this?
LOAD num(xx,'#.##0') as x, * INLINE [
or try this
LOAD num(xx,'#,##0') as x, * INLINE [
Use only Num() function don't put any formats
or simply write this
LOAD num(xx) as tt, * INLINE [
This one shuold work Num(Num#(FIELD_VALUE,'#'),'#,##0')
thank you for all the replies. i think all of your suggestion works. the problem was with the way I load my data. once i've fixed that, the normal num(fieldname, format) works.
thank you again for taking the time to reply.
Retrieving data ...