topic Re: NUM format in QlikView

NUM format

Tue, 21 May 2013 09:43:06 GMT

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.

Re: NUM format

Tue, 21 May 2013 09:52:26 GMT

try this

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

8.00

];

or try this

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

8.00

];

Re: NUM format

kumarnatarajan — Tue, 21 May 2013 09:53:16 GMT

Hi,

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

Ex: Num(FIELD_VALUE)

Re: NUM format

Tue, 21 May 2013 09:55:12 GMT

or simply write this

LOAD num(xx) as tt, * INLINE [

8.00

];

Re: NUM format

er_mohit — Tue, 21 May 2013 09:57:44 GMT

Try this

num(num#(Fieldname))

Re: NUM format

Sokkorn — Tue, 21 May 2013 10:03:11 GMT

Hi,

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

Regards,

Sokkorn

Re: NUM format

Thu, 23 May 2013 08:05:48 GMT

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.