9 Replies Latest reply: Apr 11, 2014 3:48 AM by Christian Conejero RSS

    Simple Rank() question

    Dror Svartzman

      Hi,

       

      Say i have the following table:

      ContributorPoints
      James

      300

      Lisa290
      Jake290
      Kelly150
      Sara123
      Fidel110

       

       

      In my eyes ranking the table should gives the following rank

      ContributorPoints
      James

      1

      Lisa2
      Jake2
      Kelly3
      Sara4
      Fidel5

       

      Using Rank() function, Qlikview will set Lisa and Jake both on position  '2-3'.

       

      Is it possible to give Jake and Lisa the well deserved second place ?(after all they work really hard for it

       

      Dror