Discussion Board for collaboration on QlikView Scripting.
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.
Go to Solution.
Try evaluate() when reading in the field in your script:
evaluate(FIELD) as FIELD,
That's too many digits to make a number from. QV supports 14 digits. Beyond that it will stay text.
I am getting this as result 6.0000000098634e+019
Try num(num#(column) )..
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)