topic Qlik Getting a assignee name which has assigned latest date in App Development https://community.qlik.com/t5/App-Development/Qlik-Getting-a-assignee-name-which-has-assigned-latest-date/m-p/136091#M9550 <HTML><HEAD></HEAD><BODY><P>Hi team,</P><P></P><P>I have following data.</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;-webkit-right&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 306px;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">IssueID</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Date</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Assignee</TH></TR><TR><TD align="right" height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1</TD><TD align="right" class="xl63" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1/1/2018</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">A</TD></TR><TR><TD align="right" height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1</TD><TD align="right" class="xl63" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1/2/2018</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">B</TD></TR><TR><TD align="right" height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1</TD><TD align="right" class="xl63" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1/3/2018</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">B</TD></TR><TR><TD align="right" height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1</TD><TD align="right" class="xl63" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1/4/2018</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">C</TD></TR><TR><TD align="right" height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">2</TD><TD align="right" class="xl63" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1/1/2018</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">P</TD></TR><TR><TD align="right" height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">2</TD><TD align="right" class="xl63" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1/2/2018</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">P</TD></TR></TBODY></TABLE><P></P><P></P><P>I need to have following output. what is the assignee name whom we have assigned latest issue.</P><P></P><P>for Ex ; for date&nbsp; 1/4/2018&nbsp; i need to have&nbsp; . As the for date 1/4/2018 the tickete is assign to user C.</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 189px;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">IssueID</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Assignee</TH></TR><TR><TD align="right" height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1</TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">C</TD></TR></TBODY></TABLE><P>&nbsp;&nbsp; </P><P><SPAN style="font-size: 10pt;">If we select 1/2/2018 then </SPAN></P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 189px;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">IssueID</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Assignee</TH></TR><TR><TD align="right" height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1</TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">B</TD></TR><TR><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">2</TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">P</TD></TR></TBODY></TABLE><P></P><P></P><P>Request to please let us know your input</P></BODY></HTML> Thu, 12 Jul 2018 13:42:54 GMT prashantsanchet 2018-07-12T13:42:54Z Qlik Getting a assignee name which has assigned latest date https://community.qlik.com/t5/App-Development/Qlik-Getting-a-assignee-name-which-has-assigned-latest-date/m-p/136091#M9550 <HTML><HEAD></HEAD><BODY><P>Hi team,</P><P></P><P>I have following data.</P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;-webkit-right&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 306px;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">IssueID</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Date</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Assignee</TH></TR><TR><TD align="right" height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1</TD><TD align="right" class="xl63" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1/1/2018</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">A</TD></TR><TR><TD align="right" height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1</TD><TD align="right" class="xl63" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1/2/2018</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">B</TD></TR><TR><TD align="right" height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1</TD><TD align="right" class="xl63" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1/3/2018</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">B</TD></TR><TR><TD align="right" height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1</TD><TD align="right" class="xl63" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1/4/2018</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">C</TD></TR><TR><TD align="right" height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">2</TD><TD align="right" class="xl63" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1/1/2018</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">P</TD></TR><TR><TD align="right" height="20" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">2</TD><TD align="right" class="xl63" style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1/2/2018</TD><TD style="color: #575757; text-align: -webkit-right; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">P</TD></TR></TBODY></TABLE><P></P><P></P><P>I need to have following output. what is the assignee name whom we have assigned latest issue.</P><P></P><P>for Ex ; for date&nbsp; 1/4/2018&nbsp; i need to have&nbsp; . As the for date 1/4/2018 the tickete is assign to user C.</P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 189px;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">IssueID</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Assignee</TH></TR><TR><TD align="right" height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1</TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">C</TD></TR></TBODY></TABLE><P>&nbsp;&nbsp; </P><P><SPAN style="font-size: 10pt;">If we select 1/2/2018 then </SPAN></P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 189px;"><TBODY><TR><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">IssueID</TH><TH style="color: #ffffff; background-color: #6690bc; text-align: center; padding: 2px;">Assignee</TH></TR><TR><TD align="right" height="20" style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">1</TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">B</TD></TR><TR><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">2</TD><TD style="color: #575757; text-align: left; background-color: rgba(0, 0, 0, 0); font-family: arial, helvetica, sans-serif; vertical-align: baseline;">P</TD></TR></TBODY></TABLE><P></P><P></P><P>Request to please let us know your input</P></BODY></HTML> Thu, 12 Jul 2018 13:42:54 GMT https://community.qlik.com/t5/App-Development/Qlik-Getting-a-assignee-name-which-has-assigned-latest-date/m-p/136091#M9550 prashantsanchet 2018-07-12T13:42:54Z