topic Re: Casting String to Number in QlikView

Casting String to Number

Wed, 03 Apr 2013 13:06:19 GMT

Hi,

I am having this issue, I am loading a column with 20 digits '60000000098634125780' and QV is getting it as a string but I need it to be recognized as a number.

I have tried num#(column) and it stills get it as a string and if I use the num() function it does not convert any value just drop them and leave them null.

What would you recommend to do?

Thank you for your time.

Ryu,

Re: Casting String to Number

Gysbert_Wassenaar — Wed, 03 Apr 2013 13:30:56 GMT

That's too many digits to make a number from. QV supports 14 digits. Beyond that it will stay text.

Re: Casting String to Number

swuehl — Wed, 03 Apr 2013 13:33:22 GMT

Try evaluate() when reading in the field in your script:

LOAD

evaluate(FIELD) as FIELD,

...

FROM ...;

Re: Casting String to Number

jagan — Wed, 03 Apr 2013 13:43:03 GMT

HI,

Try this

=Num(60000000098634125780)

I am getting this as result 6.0000000098634e+019

Regards,

Jagan.

Re: Casting String to Number

Wed, 03 Apr 2013 13:47:57 GMT

Try num(num#(column) )..

Re: Casting String to Number

Mon, 15 Apr 2013 10:20:19 GMT

really thanks!

i don't know why but i couldn't suppress zeros (for example from '00000000232') with the num function, but using evaluating i could obtein it (for example 232)

Re: Casting String to Number

BhargaviPK — Wed, 14 Jun 2023 08:39:39 GMT

that worked out for me! thanks!