topic Aggr function based on specified field AND dimension in Scalability https://community.qlik.com/t5/Scalability/Aggr-function-based-on-specified-field-AND-dimension/m-p/916595#M805 <HTML><HEAD></HEAD><BODY><P>Hi QlikComm,</P><P>I am trying to set a calculation which will tell me the value of the highest performing sales person based on their sales figures. I use the firstsortedvalue function with aggr, however, I want it to be calculated on the based off whatever dimension I have but of course with the salesperson as primary aggr dimension. </P><P></P><P>e.g, only have this as Expression&nbsp; firstsortedvalue(Salesperson, -aggr(sum(sales),Salesperson))</P><P></P><P>then have MONTH as dimension</P><P></P><P>I know we can add it to the expression, but the point is to use this calc in a few more objects with different dimensions.</P><P></P><P>Many thanks</P></BODY></HTML> Mon, 10 Aug 2015 01:37:58 GMT Anonymous 2015-08-10T01:37:58Z Aggr function based on specified field AND dimension https://community.qlik.com/t5/Scalability/Aggr-function-based-on-specified-field-AND-dimension/m-p/916595#M805 <HTML><HEAD></HEAD><BODY><P>Hi QlikComm,</P><P>I am trying to set a calculation which will tell me the value of the highest performing sales person based on their sales figures. I use the firstsortedvalue function with aggr, however, I want it to be calculated on the based off whatever dimension I have but of course with the salesperson as primary aggr dimension. </P><P></P><P>e.g, only have this as Expression&nbsp; firstsortedvalue(Salesperson, -aggr(sum(sales),Salesperson))</P><P></P><P>then have MONTH as dimension</P><P></P><P>I know we can add it to the expression, but the point is to use this calc in a few more objects with different dimensions.</P><P></P><P>Many thanks</P></BODY></HTML> Mon, 10 Aug 2015 01:37:58 GMT https://community.qlik.com/t5/Scalability/Aggr-function-based-on-specified-field-AND-dimension/m-p/916595#M805 Anonymous 2015-08-10T01:37:58Z Re: Aggr function based on specified field AND dimension https://community.qlik.com/t5/Scalability/Aggr-function-based-on-specified-field-AND-dimension/m-p/916596#M806 <HTML><HEAD></HEAD><BODY><P>Are you looking for this??</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/95469_Capture.PNG" style="height: 148px; width: 620px;" /></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/95470_Capture.PNG" style="height: 121px; width: 620px;" /></P></BODY></HTML> Mon, 10 Aug 2015 03:37:02 GMT https://community.qlik.com/t5/Scalability/Aggr-function-based-on-specified-field-AND-dimension/m-p/916596#M806 sunny_talwar 2015-08-10T03:37:02Z