Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
foscarini
New Contributor

Qlikview 10 - readind data from AS400 issue

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).

Tags (3)
1 Reply
foscarini
New Contributor

Qlikview 10 - readind data from AS400 issue

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