Problem reading numbers over 14 digits

[#1]

Hi, i tried to read from an txt, a couple of rows with this :

111222333444555
999888777666555

The problem is that qlikview recognized those rows as text, and a simple aggregation as sum doesnt work.

if i try with :

11122233344455
99988877766655

Qlikview recognized them as numbers and de aggregations works fine.

any ideas??

my customer wants and needs to read this kind of data.

thanks ind advance

[vgutkovsky]

Try reading them in as numbers. You can do this by enclosing the field with the num() function in the load script. For example:

num(myfieldname) as myfieldname,

Regards,

[#3]

Hi Fabian,

unfortunately "Num" will not work if your numbers have more than 14ten digits.

Now "Evaluate" comes in place. But here no decimals are allowed (111111,11).

I send a second example for a workaround.

Good luck!

Rainer

[#4]

Hi Fabian,

here are the second one using "Evaluate" , "SubField" and decimals.

Rainer