2 Replies Latest reply: Aug 28, 2017 1:47 PM by Maureen Ireland RSS

    Load max date for a row of data

    Maureen Ireland

      I am loading a table with some date fields in Qlik Sense:

       

      LOAD

        TRIM(DATE(Date1)),

        TRIM(DATE(Date2)),

        TRIM(DATE(Date3))

      FROM ...

      ;

       

      I want to add 1 more field that holds the distinct maximum date from the 3 date fields above for that row of data.

       

      Each of these date fields (as well as the new maximum date field) can be null.

       

      How do I do this?

       

      Thank you.