topic Re: maximum value in QlikView https://community.qlik.com/t5/QlikView/maximum-value/m-p/1205908#M878036 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>FirstSortedValue(Customer, -Aggr(Sum(Sales), Customer))</STRONG></P></BODY></HTML> Wed, 19 Oct 2016 15:35:12 GMT sunny_talwar 2016-10-19T15:35:12Z maximum value https://community.qlik.com/t5/QlikView/maximum-value/m-p/1205906#M878034 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P>i have to find the customer who has done maximum sales this year and i need to display in text box.</P><P></P><P>Can somebody help me with the expression please</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/maximum-value/m-p/1205906#M878034 2020-11-25T16:16:04Z Re: maximum value https://community.qlik.com/t5/QlikView/maximum-value/m-p/1205907#M878035 <HTML><HEAD></HEAD><BODY><P>Try with this</P><P></P><P><STRONG>Sum({&lt;Year, Sales= {"$(=Max(Sales))"}&gt;}Sales)</STRONG></P><P><STRONG><BR /></STRONG></P></BODY></HTML> Wed, 19 Oct 2016 15:26:11 GMT https://community.qlik.com/t5/QlikView/maximum-value/m-p/1205907#M878035 Anil_Babu_Samineni 2016-10-19T15:26:11Z Re: maximum value https://community.qlik.com/t5/QlikView/maximum-value/m-p/1205908#M878036 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>FirstSortedValue(Customer, -Aggr(Sum(Sales), Customer))</STRONG></P></BODY></HTML> Wed, 19 Oct 2016 15:35:12 GMT https://community.qlik.com/t5/QlikView/maximum-value/m-p/1205908#M878036 sunny_talwar 2016-10-19T15:35:12Z