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

    Need help in sorting top 5 values based on total

      Hi

       

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

       

       

      overview:

       

      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!!!!!!!!!!