Discussion Board for collaboration on QlikView Scripting.
When you say "my table", do you refer to the table you could look at in table viewer or do you create a chart table object using fields time and number?
If second, I guess the sort order for those fields within the object is not set to load order of field time, but something different.
Could it be that you get a concatenation to a table with fields time and number (maybe table "table"?) and you are still looking at the original order of table "table" (table view will only show you the start of the table)? Try a NOCONCATENATE LOAD then, using a label for your new table and a drop the first table (or rename the fields).
Order By StartTime;
drop Table DDSEvent_Signal2;
Are you doing something later on in your script with this table?
Have you tried not using the Qualify / Unqualify (just exiting the script after the second load, just for a test)?
Could you give an example of how your table looks like not correctly ordered?
It is probably be helpful if you could post a small sample, if you don't want to post confidential data, maybe you can use mock up data or scramble it.
Thanks, that's what I call a big example
But I was more after a sample of your input data (qvd) and your complete script (maybe just a little qvw sample?).
Honestly, I still don't know why you don't get an ordered startTime field. I would try and keep the codes as simple as possible to see what's going on.