topic Re: Max in QlikView https://community.qlik.com/t5/QlikView/Max/m-p/828935#M1018323 <HTML><HEAD></HEAD><BODY><P>Or might be</P><P>FirstSortedValue(Country,&nbsp; -Aggr(SUM(Profit),Country)</P></BODY></HTML> Tue, 31 Mar 2015 14:12:59 GMT MK_QSL 2015-03-31T14:12:59Z Max https://community.qlik.com/t5/QlikView/Max/m-p/828933#M1018321 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I have some names of countries and I have a profit per country.</P><P></P><P>Now I want a separate text box which show in which country&nbsp; I earn most profit.</P><P></P><P>How can I do that? </P></BODY></HTML> Tue, 31 Mar 2015 14:04:20 GMT https://community.qlik.com/t5/QlikView/Max/m-p/828933#M1018321 2015-03-31T14:04:20Z Re: Max https://community.qlik.com/t5/QlikView/Max/m-p/828934#M1018322 <HTML><HEAD></HEAD><BODY><P>Try</P><P>FirstSortedValue(Country, - SUM(Profit))</P></BODY></HTML> Tue, 31 Mar 2015 14:09:33 GMT https://community.qlik.com/t5/QlikView/Max/m-p/828934#M1018322 Clever_Anjos 2015-03-31T14:09:33Z Re: Max https://community.qlik.com/t5/QlikView/Max/m-p/828935#M1018323 <HTML><HEAD></HEAD><BODY><P>Or might be</P><P>FirstSortedValue(Country,&nbsp; -Aggr(SUM(Profit),Country)</P></BODY></HTML> Tue, 31 Mar 2015 14:12:59 GMT https://community.qlik.com/t5/QlikView/Max/m-p/828935#M1018323 MK_QSL 2015-03-31T14:12:59Z Re: Max https://community.qlik.com/t5/QlikView/Max/m-p/828936#M1018324 <HTML><HEAD></HEAD><BODY><P>Hi Lieko,</P><P></P><P>Try like this.....</P><P></P><P>Max(Aggr(sum(profit),country))</P><P></P><P>or</P><P></P><P>FirstSortedValue(Country, -sum(Profit))</P></BODY></HTML> Tue, 31 Mar 2015 14:16:03 GMT https://community.qlik.com/t5/QlikView/Max/m-p/828936#M1018324 2015-03-31T14:16:03Z