topic order by doesn't work in QlikView

order by doesn't work

Wed, 30 Nov 2011 11:37:27 GMT

Hi!

if i do

load time,number

resident table

order by time;

(time is numeric)

my table doesn't order by time but it is oder randomly.

order by doesn't work

swuehl — Wed, 30 Nov 2011 11:51:38 GMT

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.

order by doesn't work

Wed, 30 Nov 2011 12:29:30 GMT

i refer to the table i could look at in table viewer

order by doesn't work

swuehl — Wed, 30 Nov 2011 12:35:19 GMT

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 doesn't work

Wed, 30 Nov 2011 12:46:18 GMT

I already use NOCONCATENATE

order by doesn't work

swuehl — Wed, 30 Nov 2011 12:49:52 GMT

Could you post a small sample here (upload availabe in advanced editor)? Or your script?

Re: order by doesn't work

Wed, 30 Nov 2011 13:44:47 GMT

of course!

DDSEvent_Signal2:

LOAD

VehicleName,

VehiclesKey,

EventId,

ProcessId,

StartTime,

EndTime,

MCGFileNameId,

EnvironmentSignalGuid,

central_sample

from ./file.qvd(qvd);

DDSEvent_Signal:

QUALIFY*;

UNQUALIFY VehiclesKey,MCGFileNameId,DiagnosticConfigurationId/*,DDSEventId*/,EnvironmentSignalGuid/*,central_sample*/,VHLKey,StartTime;

NoConcatenate

LOAD

VehicleName,

VehiclesKey,

EventId,

ProcessId,

StartTime,

EndTime,

MCGFileNameId,

EnvironmentSignalGuid,

central_sample

resident DDSEvent_Signal2

Order By StartTime;

drop Table DDSEvent_Signal2;

order by doesn't work

swuehl — Wed, 30 Nov 2011 15:13:12 GMT

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.

Re: order by doesn't work

Mon, 05 Dec 2011 10:37:52 GMT

attached below my startTime column order by load order

Thanks!

order by doesn't work

swuehl — Mon, 05 Dec 2011 18:45:13 GMT

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.

order by doesn't work

Sokkorn — Tue, 06 Dec 2011 01:33:51 GMT

Hi Davide,

I really don't get your point, but maybe you need to view order in table viewer. If so then we ask this question:

1. Why I need to view order in table viewer?

2. If I can sort order in table viewer, what is the benefit for developer? What is extra load time and process when use order by?

3. Our customer need to sort order in table viewer or in QlikView object (Straight Table, Pivot Table,...)?

So from my idea is do not sort order in load script. I prefer sort order in QlikView object.

Regards,

Sokkorn Cheav

Re: order by doesn't work

Tue, 06 Dec 2011 12:50:39 GMT

hi sokkorn,

I need to order the table on load statement because I need to use fieldindex() and this function works on load order.

Re: order by doesn't work

Tyler_Waterfall — Wed, 16 Oct 2013 12:40:09 GMT

I know this is quite an old post, but I am also not able to get the ORDER BY to work (11.20) in the load script when used as described in the help (resident load, etc.)

Re: order by doesn't work

swuehl — Wed, 16 Oct 2013 12:42:58 GMT

Tyler,

I would suggest that you open a new thread.

Please add as many information as possible (best using a small sample app that demonstrates your issue).