topic QVD file Sorting order. in QlikView

QVD file Sorting order.

Tue, 11 Feb 2014 09:21:58 GMT

Hi All,

When i am reading(loading) data from QVD files, Sorting (Order by <Column Name>) possible?. i am not using into Residential load.

For Ex,

Load … from customer.qvd(qvd)

Order by Order_DT_Ev.

Regards,

Raja.

Re: QVD file Sorting order.

Tue, 11 Feb 2014 09:32:36 GMT

No ... Order by works only in Residential load ...

Re: QVD file Sorting order.

luis_pimentel — Tue, 11 Feb 2014 09:35:45 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,

Luis.

Re: QVD file Sorting order.

agilos_mla — Tue, 11 Feb 2014 09:37:12 GMT

Sorting (ORDER BY) is only possible with Resident (already in memory) files.

Sorting is not possible when reading from files.

You could add a sort order before Storing the data in the QVD.

Michael

Re: QVD file Sorting order.

Tue, 11 Feb 2014 09:37:24 GMT

try this

Load … from customer.qvd(qvd)

Order by [Order_DT_Ev.] asc ;

Re: QVD file Sorting order.

Sokkorn — Tue, 11 Feb 2014 10:09:16 GMT

Hi Raja,

Here is a trick

Load * Order By FieldName;

Load ...

from customer.qvd (qvd);

Regards,

Sokkorn

Re: QVD file Sorting order.

Tue, 11 Feb 2014 10:21:11 GMT

Hi Kumar,

Thanks for your quick response.

I attempt your script but I am unsuccessful customer is not ascending order.

Regards,

Raja.

Re: QVD file Sorting order.

Tue, 11 Feb 2014 10:22:01 GMT

Hi Sokkom,

Thanks for your quick response.

Regards.

Raja.

Re: QVD file Sorting order.

Tue, 11 Feb 2014 10:22:33 GMT

Hi Luis,

Thanks for your quick response.