Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
josephinetedesc
Creator III
Creator III

syntax in Qlikview for using "order by"

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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;

View solution in original post

4 Replies
tresesco
MVP
MVP

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
Creator III
Creator III
Author

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
MVP
MVP

Yes.

josephinetedesc
Creator III
Creator III
Author

It worked - thank you! thank you!

Jo