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