Discussion Board for collaboration related to QlikView App Development.
Can you use 'Order By' in a QVD Load? It looks like my syntax is good but I get this error:
Garbage after statement
FROM C:\QlickView\Dashboard\PATIENTLEVELDATA_4.QVD (qvd) Order By RECDATE
Go to Solution.
Coming to your data.
from C:\QlickView\Dashboard\PATIENTLEVELDATA_4.QVD (qvd);
Load *,1 as Flag
Resident Temp Order By RECDATE;
Drop table Temp;
No you can't use Order By clause for qvd file. You can use for resident table only.
Load A,B*C as E resident tab1 order by A;
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
FROM FileName.QVD (qvd);
ORDER BY Field1, Field2;
DROP TABLE TempTable;
Hope this helps you.
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."
Thanks for the answer!
please check in sheet 1 and sort by key or sale whatever you take and show me the result.