4 Replies Latest reply: Dec 4, 2015 12:00 AM by Jo Tedesco RSS

    syntax in Qlikview for using "order by"

    Jo Tedesco
      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