https://community.qlik.com/t5/App-Development/User-with-least-time-for-transaction/m-p/1621355#M46258 <P>Hello,</P><P>What to Display User with least time for transactions</P><P>avg({&lt;Year={$(vMaxYear)},DateType={'RECEIVED_DATE'},WF_TASK_NAME_Time = {'ApprovalTask'},WORK_TIME-={'-1'}&gt;}WORK_TIME)</P><P>How i can use Aggr() or Rank() to display only the name of user with least time taken for transaction on average</P><P>(Assuming user field is<SPAN>&nbsp;</SPAN><STRONG>USER_ID</STRONG>)</P> Sat, 16 Nov 2024 04:44:38 GMT Alarkis 2024-11-16T04:44:38Z https://community.qlik.com/t5/App-Development/User-with-least-time-for-transaction/m-p/1621355#M46258 <P>Hello,</P><P>What to Display User with least time for transactions</P><P>avg({&lt;Year={$(vMaxYear)},DateType={'RECEIVED_DATE'},WF_TASK_NAME_Time = {'ApprovalTask'},WORK_TIME-={'-1'}&gt;}WORK_TIME)</P><P>How i can use Aggr() or Rank() to display only the name of user with least time taken for transaction on average</P><P>(Assuming user field is<SPAN>&nbsp;</SPAN><STRONG>USER_ID</STRONG>)</P> Sat, 16 Nov 2024 04:44:38 GMT https://community.qlik.com/t5/App-Development/User-with-least-time-for-transaction/m-p/1621355#M46258 Alarkis 2024-11-16T04:44:38Z https://community.qlik.com/t5/App-Development/User-with-least-time-for-transaction/m-p/1623286#M46417 <P>Try this:</P><LI-CODE lang="markup">=Only({&lt;USER_ID = {"=Rank(avg({&lt;Year={$(vMaxYear)},DateType={'RECEIVED_DATE'},WF_TASK_NAME_Time = {'ApprovalTask'},WORK_TIME-={'-1'}&gt;}WORK_TIME)) = 1"}&gt;}USER_ID)</LI-CODE> Thu, 12 Sep 2019 15:19:26 GMT https://community.qlik.com/t5/App-Development/User-with-least-time-for-transaction/m-p/1623286#M46417 treysmithdev 2019-09-12T15:19:26Z