topic Re: Can you use 'Order By' in a QVD Load? in QlikView

Can you use 'Order By' in a QVD Load?

Wed, 18 Apr 2012 14:37:54 GMT

Can you use 'Order By' in a QVD Load? It looks like my syntax is good but I get this error:

Garbage after statement

PATIENTLEVELDATA:

LOAD SURVEY_ID,

CLIENT_ID,

SERVICE,

RECDATE,

DISDATE,

%Key_PATIENTLEVELDATA_E1A59225A73AF151

FROM C:\QlickView\Dashboard\PATIENTLEVELDATA_4.QVD (qvd) Order By RECDATE

Can you use 'Order By' in a QVD Load?

jagannalla — Wed, 18 Apr 2012 14:40:38 GMT

No you can't use Order By clause for qvd file. You can use for resident table only.

Eg:

Load A,B*C as E resident tab1 order by A;

Can you use 'Order By' in a QVD Load?

jagannalla — Wed, 18 Apr 2012 14:43:56 GMT

Coming to your data.

Temp:

Load *

from C:\QlickView\Dashboard\PATIENTLEVELDATA_4.QVD (qvd);

PATIENTLEVELDATA:

Load *,1 as Flag

Resident Temp Order By RECDATE;

Drop table Temp;

Can you use 'Order By' in a QVD Load?

jagan — Wed, 18 Apr 2012 16:05:58 GMT

Hi,

You can use order by only in Resident load only. If you want to use order by then load QVD data into temporary table and then using resident load sort the data and then drop the temporary table. Check the script below

TempTable:

LOAD

FROM FileName.QVD (qvd);

Data:

LOAD

RESIDENT TempTable

ORDER BY Field1, Field2;

DROP TABLE TempTable;

Hope this helps you.

Regards,

Jagan.

Re: Can you use 'Order By' in a QVD Load?

Sat, 23 Jul 2016 16:53:01 GMT

I did not realize this constraint on the ORDER BY clause: (described in Qlikview documentation) "This clause may only be used when the data source is a resident table."

Re: Can you use 'Order By' in a QVD Load?

Tue, 23 Aug 2016 09:16:58 GMT

Thanks for the answer!

Re: Can you use 'Order By' in a QVD Load?

gauravkumar131 — Thu, 07 Feb 2019 18:38:04 GMT

hey jaganand,

please check in sheet 1 and sort by key or sale whatever you take and show me the result.