NUM format

[#1]

Hi,

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?

Thanks.

[#2 · Accepted solution]

try this

LOAD num(xx,'#.##0') as x, * INLINE [

    xx

    8.00

    1

];

or try this

LOAD num(xx,'#,##0') as x, * INLINE [

    xx

    8.00

    1

];

[kumarnatarajan]

Hi,

Use only Num() function don't put any formats

Ex: Num(FIELD_VALUE)

[#4]

or simply write this

LOAD num(xx) as tt, * INLINE [

    xx

    8.00

    1

];

[er_mohit]

Try this

num(num#(Fieldname))

[Sokkorn]

Hi,

This one shuold work Num(Num#(FIELD_VALUE,'#'),'#,##0')

Regards,

Sokkorn

[#7]

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.