15 Replies Latest reply: Apr 4, 2016 4:17 AM by xavier hemelaar RSS

    Find a unique max date

    xavier hemelaar

      Hi Qlikers,

      I have a table and based on several conditions I want to find a unique date for each ID.

      The table is:

      IDNUMNAMEDATE
      110John01/03/2016
      120Mike12/03/2016
      130Tom14/03/2016
      210John04/03/2016
      220Tom10/03/2016
      230Mike10/03/2016
      240David06/03/2016

      So basicaly the first think to do is to find the max DATE for each ID. For some ID you can have several lines with the same max DATE. In this case we look for the max NUM.

      The expected result is:

      IDNUMNAMEDATE
      130Tom14/03/2016
      230Mike10/03/2016

       

      I tried a few things with GROUP BY, but the reultisn't there yet.

       

      Thanks for your help