topic Name of maximum value in QlikView https://community.qlik.com/t5/QlikView/Name-of-maximum-value/m-p/646841#M1072162 <HTML><HEAD></HEAD><BODY><P>How can I get of the name of maximum value</P></BODY></HTML> Fri, 08 Aug 2014 10:30:07 GMT 2014-08-08T10:30:07Z Name of maximum value https://community.qlik.com/t5/QlikView/Name-of-maximum-value/m-p/646841#M1072162 <HTML><HEAD></HEAD><BODY><P>How can I get of the name of maximum value</P></BODY></HTML> Fri, 08 Aug 2014 10:30:07 GMT https://community.qlik.com/t5/QlikView/Name-of-maximum-value/m-p/646841#M1072162 2014-08-08T10:30:07Z Re: Name of maximum value https://community.qlik.com/t5/QlikView/Name-of-maximum-value/m-p/646842#M1072163 <HTML><HEAD></HEAD><BODY><P>This can be done by FirstSortedValue.Please find the application file</P></BODY></HTML> Fri, 08 Aug 2014 10:39:21 GMT https://community.qlik.com/t5/QlikView/Name-of-maximum-value/m-p/646842#M1072163 2014-08-08T10:39:21Z Re: Name of maximum value https://community.qlik.com/t5/QlikView/Name-of-maximum-value/m-p/646843#M1072164 <HTML><HEAD></HEAD><BODY><P>Are you not sorting by the individual values of Value? If you sort the individual values from biggest to lowest they are the same as doing it for sums of values. I think a correct way to do it is to use the expressions:</P><P></P><P>max:</P><P>=FirstSortedValue(Name,-aggr(sum(Value),Name))</P><P></P><P>and</P><P></P><P>min:</P><P>=FirstSortedValue(Name,aggr(sum(Value),Name))</P></BODY></HTML> Fri, 08 Aug 2014 10:47:16 GMT https://community.qlik.com/t5/QlikView/Name-of-maximum-value/m-p/646843#M1072164 simenkg 2014-08-08T10:47:16Z Re: Name of maximum value https://community.qlik.com/t5/QlikView/Name-of-maximum-value/m-p/646844#M1072165 <HTML><HEAD></HEAD><BODY><P>thank you</P></BODY></HTML> Fri, 08 Aug 2014 10:51:49 GMT https://community.qlik.com/t5/QlikView/Name-of-maximum-value/m-p/646844#M1072165 2014-08-08T10:51:49Z