Data transformation error after loading negative amount with decimals

[#1]

Hi,

I stumbled upon a problem, Qlikview seems to reformat data i read from a view in my SQL database.

My load script leaves the data unchanged:

LOAD LEDGERTRANSDATE,

    PROJID as PTP_PROJID,

    VOUCHER,

    TRANSID,

    PROJTRANSDATE,

    DIMENSION as Afdeling,

    "DIMENSION2_" as Kostenplaats,

    "DIMENSION3_" as Doel,

    PROJTRANSTYPE as TRANSACTIETYPEID,

    AMOUNTMST,

    OFFSETACCOUNT;

SQL SELECT *

FROM MRPRJPROJTRANSPOSTING;

Looking at the data from within SQL Server, i see the following:

The AMOUNTMST field after loading in Qlikview shows the following:

So the first number seems to be rounded, but as for the second number i haven't got a clue.

Any suggestions anyone?

Kind regards,

Herman

[m_woolf · Accepted solution]

In the first picture the Account is 08510.

In the second picture it is 013211.

Are you looking at the same numbers?

[#3]

Right.... In the connection string a different database was attached. Because most id's are the same (one db being a clone of the other), i didn't notice this. Thank you!

This makes a fine first post....