15 Replies Latest reply: Jan 10, 2014 1:30 PM by John Lifter RSS

    Max Date in Qlikview Expressor

      Hi everyone,

       

      Just wondering if anyone could help me here.

       

      I have loaded a table using read file in expressor.

       

      One of the fields, a string, is a date field with a format YYYYMMDD.

       

      Imagine a scenario where I have an ID field say LocationID and I want a table with LocationID & Max Date Field how can this be performed in expressor?

       

      I can change the format of a string to date using string.datetime(DateField,"YYYYMMDD") but how do I create the logic of Max(DateField)?

       

      Below is the code in Qlikview Script:

       

      Load LocationID&'-'&Max(date(DateField)) as LocationDateID resident mytable group by LocationID;

       

      Thanks,

      Eliano