4 Replies Latest reply: Jul 27, 2012 5:38 AM by pulinkul RSS

    Need help in sorting top 5 values based on total



      I'm Anand  and  am very new to qlikview , so i request you guys to help me out from this challenge





      In the qlikview and excel document attached there are "departments" as a,b,c,d, and their quarter sales in the tenure or quarter mentioned above

      and the last total column is the performance and sum of all quarters


      challenge is :


      I need a table chart which can display the result of top performers based on the total and should display only the top 5 departments and the remaining departments should be included in "all others " which comes after the top 5 performers as shown in the excel image  attached .




      what expression should be used to solve this challenge and where i should use that expression.



      kindly help!!!!!!!!!!