Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

1 Solution

Accepted Solutions
mwoolf
Not applicable

Re: Data transformation error after loading negative amount with decimals

In the first picture the Account is 08510.

In the second picture it is 013211.

Are you looking at the same numbers?

2 Replies
mwoolf
Not applicable

Re: Data transformation error after loading negative amount with decimals

In the first picture the Account is 08510.

In the second picture it is 013211.

Are you looking at the same numbers?

Not applicable

Re: Data transformation error after loading negative amount with decimals

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