Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

prashantsanchet
Contributor

Qlik Getting a assignee name which has assigned latest date

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

Community Browser