This content has been marked as final. Show 2 replies
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:
PROJID as PTP_PROJID,
DIMENSION as Afdeling,
"DIMENSION2_" as Kostenplaats,
"DIMENSION3_" as Doel,
PROJTRANSTYPE as TRANSACTIETYPEID,
SQL SELECT *
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?