8 Replies Latest reply: Sep 17, 2018 6:48 PM by vidya sagar malla RSS

    Ranking on Multiple Dimensions

    vidya sagar malla

      Hi,

       

      I am using QlikSense web edition. I am trying to achieve Ranks based on two-dimensional values. Please find the sample data below.

       

         

      YearFundPriceRank
      2018A4001
      2018B3002
      2018C2003
      2018D1004
      2017A1004
      2017B2003
      2017C3002
      2017D4001

       

      The expression I tried is not working as expected:

       

      =AGGR(Rank(sum([Price])),Fund,[Year])

       

      Help would be appreciated.

       

      Thanks,

      -Vidya