How to load from QVD ordering by a field - Qlik Community

Report Inappropriate Content · ‎2012-09-24

load

* from \Pruebas\PROY_PRODUCCIONES\ACTPRODUCCIONES.QVD (qvd);

Can anyboy help me please?

Thanks

Report Inappropriate Content · ‎2012-09-24

Hi,

If it is something like an order number or date, it should work like this:

Load

*

From

\Pruebas\PROY_PRODUCCIONES\ACTPRODUCCIONES.QVD (qvd)

Order By

Order_no ASC;

If you search in the help section there will also be some examples there.

Regards,

Emma

Report Inappropriate Content · ‎2012-09-24

For some reason it seems like load...qvd is not compatible with "order by".

I wrote the script like this:

* from \\Qlikview\Pruebas\PROY_PRODUCCIONES\ACTPRODUCCIONES.QVD (qvd)
Order By FECHA ASC;

After reading the qvd it gaves me an error script "Palabras no reconocidas después de la sentencia (Not recognized words after de sentence)

load * from \\Qlikview\Pruebas\PROY_PRODUCCIONES\ACTPRODUCCIONES.QVD (qvd)

Order By FECHA ASC"

load

Report Inappropriate Content · ‎2012-09-24

Have you tried without “Load *” and instead list the field names?

Emma Self

Business Information Manager | Investment Property Management

Direct +44 20 7487 1692

Main +44 20 7935 4499

emma.self@colliers.com <mailto:emma.self@colliers.com> <mailto:>

Colliers International

9 Marylebone Lane | London W1U 1HL | United Kingdom

www.colliers.com/uk

Colliers International is the licensed trading name of Colliers International Property Consultants Limited. Company registered in England & Wales no. 7996509. Registered office: 9 Marylebone Lane, London W1U 1HL.

Colliers International Property Consultants Limited is an Appointed Representative of Oval Insurance Broking Limited. Oval Insurance Broking Limited is authorised and regulated by the Financial Services Authority.

Confidentiality Notice: This communication and the information it contains: (a) is intended for the person(s) or Organisation(s) named above and for no other persons or organisations and, (b) may be confidential, legally privileged and protected by law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you receive this communication in error, please notify us immediately, destroy any copies and delete it from your computer system.

Report Inappropriate Content · ‎2012-09-24

I’ve just re-read the QlikView Help and it looks like Order can only be used on resident loads:

order by is a clause used for sorting the records of a resident input table before they are processed by the load statement. The resident table can be sorted by one or more fields in ascending or descending order. The sorting is made primarily by numeric value and secondarily by national ASCII value. This clause may only be used when the data source is a resident table.