1 Reply Latest reply: Aug 9, 2015 11:37 PM by Sunny Talwar RSS

    Aggr function based on specified field AND dimension

    danny rock

      Hi QlikComm,

      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.

       

      e.g, only have this as Expression  firstsortedvalue(Salesperson, -aggr(sum(sales),Salesperson))

       

      then have MONTH as dimension

       

      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.

       

      Many thanks