2 Replies Latest reply: Sep 25, 2015 9:00 AM by Sally Parkes RSS

    RANK formula is not ranking in the correct order

      This is my first post having only joined the forum today.  I am also new to using QlikView.  Be gentle!

       

      This concerns the Rank formula for ranking recruitment.  I want the Rank and Rank(adj) columns to rank the entries based on the Raw Recruitment Total and Adjusted Recruitment Total columns, respectively.  However, the order of the rankings is incorrect.  For example, looking at the Raw Recruitment, the second highest recruitment total is ranked 9 when it should be 2.

       

      The screen shots below show how the pivot table has been set up.  What am I doing wrong?  Many thanks, Parkes84

      Rank1.bmp

      Rank2.bmp

      Rank3.bmp