0 Replies Latest reply: Jul 12, 2018 9:42 AM by Prashant Sancheti RSS

    Qlik Getting a assignee name which has assigned latest date

    Prashant Sancheti

      Hi team,

       

      I have following data.

         

      IssueIDDateAssignee
      11/1/2018A
      11/2/2018B
      11/3/2018B
      11/4/2018C
      21/1/2018P
      21/2/2018P

       

       

      I need to have following output. what is the assignee name whom we have assigned latest issue.

       

      for Ex ; for date  1/4/2018  i need to have  . As the for date 1/4/2018 the tickete is assign to user C.

        

      IssueIDAssignee
      1C

        

      If we select 1/2/2018 then

       

        

      IssueIDAssignee
      1B
      2P

       

       

      Request to please let us know your input