Discussion Board for collaboration on QlikView Scripting.
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?
Go to Solution.
In the first picture the Account is 08510.
In the second picture it is 013211.
Are you looking at the same numbers?
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....