syntax in Qlikview for using "order by"

[josephinetedesc]

https://community.qlik.com/message/197287#197287

Hi All

I currently get a qlikview document to work by running the SQL, then creating a QVD file.  I want to sore the QVD file according to Person ID.  (Currently I make it an Excel file and sort it according to personID)

Directory;

LOAD

     PersonID,

     dateCT,

     dateQA

FROM

[Table3.qvd]

(qvd)

//ORDER BY PersonID, dateCT

;

The sql that I run to get the table sorted is shown below - then I copy this into an Excel file:

SELECT *

FROM vw_tableOfDates

ORDER BY PersonID, dateCT

;

Is there an easier way of doing this?  Order by does not work in QlikView?

Thank you for any help.

Jo

[tresesco · Accepted solution]

Order By works in QlikView. It is just that you have to use it with Resident load. Try like:

Temp:

LOAD

     PersonID,

     dateCT,

     dateQA

FROM

[Table3.qvd]

(qvd);

NoConcatenate

Fina:

LOAD

     PersonID,

     dateCT,

     dateQA

Resident Temp ORDER BY PersonID, dateCT ;

Drop table Temp;

[josephinetedesc]

ok ... sort of

if I have a calculated field that depends on Previous function - I would need to use it in the Fina table load?

Jo

[tresesco]

Yes.

[josephinetedesc]

It worked - thank you! thank you!

Jo