6 Replies Latest reply: Aug 5, 2013 5:02 PM by Jeroen Jordaan RSS

    Find minimum &max ranked to use in text box

      Below is a table of data that I've loade in to a QVW:

       

      RankExample.png

       

      I need to have a couple of text boxes showing various peices of info - namely, the top ranked 'Branch', with it's 'GP', and the other two fields - each in it's own text box.

       

      In addition, I'll need the lowest ranked 'Branch', and it's associated fields.

       

      I've got an expression using Rank() to pick the highest ranked Branch, but I'm not sure how to pick the lowest (based on GP or $ Increase):

       

      =aggr(if(rank(sum({1<PeriodYear = {2013}>} GP))<=1,Branch),Branch)

       

      Thanks for your help!

       

      S.