2 Replies Latest reply: Mar 8, 2016 11:04 AM by Sunny Talwar RSS

    How to show max value row in straight table for Uniq ID?

    Christian Dahl

      Hello Im new here,

       

      I have below data in a MySQL DataBase. I need to show only the max date for a Uniq Value in a row for a straight table in Qlik Sense.

      Can anyone please help / point me in the right direction. I have generated MAX(DATE) but need to remove the rows with the same UniqID so I only have one UniqID and one row.

       

      INPUT:

       

      UniqIDNameService TypeExpiryDateMAX DATEConsult Hours
      Ad102ADAMIT

      21/10/2014

        16:58

      21/10/2014

        16:58

      7
      Ad102ADAMProgramming

      12/10/2012

        08:50

      21/10/2014

        16:58

      3
      Ad102ADAMIT

      09/09/2011

        11:11

      21/10/2014

        16:58

      2
      Bs899BenProgramming

      09/02/2010

        12:58

      01/03/2016

      09:11

      2
      Bs899BenProgramming

      01/03/2016

      09:11

      01/03/2016

      09:11

      5


      I need the following in the OutPut:

      UniqIDNameService TypeExpiryDateMAX DATEConsult Hours
      Ad102ADAMIT

      21/10/2014

        16:58

      21/10/2014

        16:58

      7
      Bs899BenProgramming

      01/03/2016

      09:11

      01/03/2016

      09:11

      5

       

      Hope it makes sense