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:


      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


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


      Thanks in advance.