topic Problem reading numbers over 14 digits in QlikView

Problem reading numbers over 14 digits

Wed, 10 Mar 2010 23:19:11 GMT

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 — Wed, 10 Mar 2010 23:26:15 GMT

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,

Thu, 11 Mar 2010 12:17:58 GMT

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

Thu, 11 Mar 2010 12:30:48 GMT

Hi Fabian,

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

Rainer