Discussion Board for collaboration on QlikView Scripting.
Hi everyone, Weirdest thing.
I've got the most basic of scripts:
SQL SELECT "CrstId",
In Qlik Sense, this results in:
001, another description
and so on
In SQL, it results in:
and so on.
The SQL statement is copy-paste. Any idea why i receive multiple values (wrong values by the way) in Qlik, but not in SQL Server?
Sometimes, you need a weekend, or at least in my case I do
Found out by looking at the raw data that Qlik was adding leading zeroes to the actual value in the Id field.
So 001 stayed 001, but 1 became 001.
Adding Text() fixed this for me.
Text ([CrstId]) as [CrstId],
Thanks for your time!
View solution in original post
Are you connecting to the same databses? Hope not to a test db from sense?
yes, it's the same DB.
May be you are loading some historic data before the sql stmt?
Try using Preceeding load
noconcatenate load *