topic How to load from QVD ordering by a field in QlikView

How to load from QVD ordering by a field

Mon, 24 Sep 2012 08:17:37 GMT

load

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

Can anyboy help me please?

Thanks

Re: How to load from QVD ordering by a field

Mon, 24 Sep 2012 08:25:42 GMT

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

Re: How to load from QVD ordering by a field

Mon, 24 Sep 2012 09:27:03 GMT

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

Re: How to load from QVD ordering by a field

Mon, 24 Sep 2012 09:28:17 GMT

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.

Re: How to load from QVD ordering by a field

Mon, 24 Sep 2012 09:32:29 GMT

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.

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