topic Show Customer Name that has largest outstanding value in QlikView https://community.qlik.com/t5/QlikView/Show-Customer-Name-that-has-largest-outstanding-value/m-p/441892#M484613 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In a text box, i would like to show the name of Customer that has the largest amount outstanding, a customer can have several transactions with outstanding values so i would need to sum these values and then determine who has the largest.</P><P></P><P>how can i do this?</P><P></P><P>The fields i have are CustomerName and OutstandingValue.</P><P></P><P>Thanks,</P><P>Sunil</P></BODY></HTML> Wed, 05 Jun 2013 11:43:15 GMT Sunil_Kenth 2013-06-05T11:43:15Z Show Customer Name that has largest outstanding value https://community.qlik.com/t5/QlikView/Show-Customer-Name-that-has-largest-outstanding-value/m-p/441892#M484613 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In a text box, i would like to show the name of Customer that has the largest amount outstanding, a customer can have several transactions with outstanding values so i would need to sum these values and then determine who has the largest.</P><P></P><P>how can i do this?</P><P></P><P>The fields i have are CustomerName and OutstandingValue.</P><P></P><P>Thanks,</P><P>Sunil</P></BODY></HTML> Wed, 05 Jun 2013 11:43:15 GMT https://community.qlik.com/t5/QlikView/Show-Customer-Name-that-has-largest-outstanding-value/m-p/441892#M484613 Sunil_Kenth 2013-06-05T11:43:15Z Re: Show Customer Name that has largest outstanding value https://community.qlik.com/t5/QlikView/Show-Customer-Name-that-has-largest-outstanding-value/m-p/441893#M484614 <HTML><HEAD></HEAD><BODY><P>Try using:</P><P></P><P>=Firstsortedvalue(CustomerName, -<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">OutstandingValue</SPAN>)</P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Wed, 05 Jun 2013 11:47:57 GMT https://community.qlik.com/t5/QlikView/Show-Customer-Name-that-has-largest-outstanding-value/m-p/441893#M484614 sushil353 2013-06-05T11:47:57Z Re: Show Customer Name that has largest outstanding value https://community.qlik.com/t5/QlikView/Show-Customer-Name-that-has-largest-outstanding-value/m-p/441894#M484615 <HTML><HEAD></HEAD><BODY><P>Thanks Sushil</P></BODY></HTML> Wed, 05 Jun 2013 11:53:53 GMT https://community.qlik.com/t5/QlikView/Show-Customer-Name-that-has-largest-outstanding-value/m-p/441894#M484615 Sunil_Kenth 2013-06-05T11:53:53Z