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;