2 Replies Latest reply: Mar 6, 2013 10:14 AM by hermaneh RSS

    Data transformation error after loading negative amount with decimals

      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:

      sql.png

      The AMOUNTMST field after loading in Qlikview shows the following:

      QV-wrong-decimals.png

       

      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