Qlikview 10 - readind data from AS400 issue

Anonymous — Thu, 24 May 2012 11:57:37 GMT

Hi all,

I've an issue while reading data from an as400 file.

I'm doing a simply select statement like:

select <field> from table.

The field is a numeric field (13,2), and I assume it should be with 2 decimal numbers.

By the way if I Override the Document Settings and I set it fixed to 14 Decimals, strange numbers appears in the decimal position.

e.g.:

The correct number should be -73881.71, but with the 14 decimal visualization I get -73881.71000000000600

I'm damn sure that in AS400 the correct number is -73881.71

Can anybody give me a hint please ?

Thanks in advance

Alessio

If it's needed I can attach the qlik file (even if the connection will not work of course).

Anonymous — Mon, 28 May 2012 13:59:06 GMT

I've an Update, if anybody is interested:

if I load the data of a single Customer, the number is correct, without any additional decimal number.

If I load the data of billions of Customer, the number isn't correct anymore.

Hope somebody will help me.

Thanks

topic Qlikview 10 - readind data from AS400 issue in QlikView