4 Replies Latest reply: Nov 23, 2016 5:06 AM by Tyrone Fay RSS

    Dynamic Grouping by Rank @Qlikview

    Alexander Müller

       

      Hello everyone

      I have a problem with grouping of data. My idea is to show in a bar chart the revenues of Top 10, Top 20, and Top 30 etc companies.

      Goal is to have a “clustered” output. As dimension, grouped companies (“Top 10”, “Top 20”, “Top 30”, …) would be perfect.

      The data is structured as follows: 

      Company

      Revenue

      A

      100

      A

      200

      B

      300

      C

      50

       

      As example one of the used expressions:

      =if(Rank(Sum([Revenue]))<=20 and Rank(Sum([Revenue]))>10, sum([Revenue]))”

      I tried the class function and worked with dynamic dimensions – nothing worked the way I wanted.

      To guarantee dynamic selection I do not want to group it within the load script.

      Thanks for any idea - wish you a great Sunday!

      Example of the output needed: