topic Re: Return String based on Highest Count in QlikView https://community.qlik.com/t5/QlikView/Return-String-based-on-Highest-Count/m-p/505284#M480379 <HTML><HEAD></HEAD><BODY><P>This works!</P><P></P><P>Thanks a lot for the help</P></BODY></HTML> Thu, 28 Nov 2013 17:50:54 GMT 2013-11-28T17:50:54Z Return String based on Highest Count https://community.qlik.com/t5/QlikView/Return-String-based-on-Highest-Count/m-p/505282#M480377 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>In a text field I want to display the name of a value with the highest count.</P><P></P><P>So far I have this</P><P></P><P>=MaxString(aggr(Count({1&lt;[Billable_Status] = {Billable}&gt;}Practice)Practice))</P><P></P><P>This returns back the highest count of billable employees in a practice, but I want it to display the name of the practice not the count.</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 28 Nov 2013 17:15:01 GMT https://community.qlik.com/t5/QlikView/Return-String-based-on-Highest-Count/m-p/505282#M480377 2013-11-28T17:15:01Z Re: Return String based on Highest Count https://community.qlik.com/t5/QlikView/Return-String-based-on-Highest-Count/m-p/505283#M480378 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=FirstSortedValue( YourNamefield, - aggr(Count({1&lt;[Billable_Status] = {'Billable'}&gt;}Practice), Practice) )</SPAN></P></BODY></HTML> Thu, 28 Nov 2013 17:35:12 GMT https://community.qlik.com/t5/QlikView/Return-String-based-on-Highest-Count/m-p/505283#M480378 tresB 2013-11-28T17:35:12Z Re: Return String based on Highest Count https://community.qlik.com/t5/QlikView/Return-String-based-on-Highest-Count/m-p/505284#M480379 <HTML><HEAD></HEAD><BODY><P>This works!</P><P></P><P>Thanks a lot for the help</P></BODY></HTML> Thu, 28 Nov 2013 17:50:54 GMT https://community.qlik.com/t5/QlikView/Return-String-based-on-Highest-Count/m-p/505284#M480379 2013-11-28T17:50:54Z