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)
//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:
ORDER BY PersonID, dateCT
Is there an easier way of doing this? Order by does not work in QlikView?