3 Replies Latest reply: Oct 11, 2018 12:43 PM by omar bensalem RSS

    Count ID with Max(OutDate)

    Raman Singh

      Hi All,

       

      Hope someone is able to help me with this issue.

       

      I have a table containing the below data:

       

      IDPartNoPartNoOutReceivedDateOutDate
      3037680-132-0039000002370152018-04-10 16:08:00.0002018-05-31 16:12:42.567
      3037680-132-0039000002461102018-04-10 16:08:00.0002018-08-28 13:17:09.173
      3037680-132-0039000002502462018-04-10 16:08:00.0002018-05-31 16:12:42.567

       

      I need to create a table in Qlik counting numbers of units out but using the MAX(OutDate). So the table in Qlik will show as the following:

       

      Month/YearUnits Out
      Oct-20181

       

      As the ID is the same I only need to count this as one unit out.

       

      Thanks in advance.