topic Re: Rank function problem in QlikView https://community.qlik.com/t5/QlikView/Rank-function-problem/m-p/992143#M338010 <HTML><HEAD></HEAD><BODY><P>Try FirstSortedValue(Area, -aggr(sum(Value), Agency, Area)) as expression to return the Area and max(aggr(sum(Value),Agency,Area)) as expression for the maximum sum of value.</P></BODY></HTML> Sun, 04 Oct 2015 14:32:24 GMT Gysbert_Wassenaar 2015-10-04T14:32:24Z Rank function problem https://community.qlik.com/t5/QlikView/Rank-function-problem/m-p/992142#M338009 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i have this situation, top 10 agencies with decrescent value:</P><P></P><P><IMG alt="imae.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/100897_imae.png" style="height: auto;" /></P><P></P><P>I need to have for every agency the max value Area.</P><P>How can i do?</P><P></P><P>I have two dimension:</P><P></P><P>Agency as calculated dimension&nbsp; = "if(aggr(rank(sum(Value)),[AGENCY NAME])&lt;=10,[AGENCY NAME]) "</P><P>and Area as normal dimension.</P><P></P><P>Thanks a lot</P></BODY></HTML> Sun, 04 Oct 2015 14:18:09 GMT https://community.qlik.com/t5/QlikView/Rank-function-problem/m-p/992142#M338009 2015-10-04T14:18:09Z Re: Rank function problem https://community.qlik.com/t5/QlikView/Rank-function-problem/m-p/992143#M338010 <HTML><HEAD></HEAD><BODY><P>Try FirstSortedValue(Area, -aggr(sum(Value), Agency, Area)) as expression to return the Area and max(aggr(sum(Value),Agency,Area)) as expression for the maximum sum of value.</P></BODY></HTML> Sun, 04 Oct 2015 14:32:24 GMT https://community.qlik.com/t5/QlikView/Rank-function-problem/m-p/992143#M338010 Gysbert_Wassenaar 2015-10-04T14:32:24Z