5 Replies Latest reply: May 12, 2015 11:35 AM by anbu cheliyan RSS

    How to rank customers within groups

      Hi,

       

      I want to populate rank within groups. Please help.

       

      For example, this is what my data looks like:

       

      Customer IDDepartmentRevenue
      1A10
      1B12
      1C13
      1D14
      1E15
      2B6
      2C7
      2D8
      2E9

       

      I want to populate rank as shown below for each customer:

       

       

      Customer IDDepartmentRevenueRank
      1A101
      1B122
      1C133
      1D144
      1E155
      2B61
      2C72
      2D83
      2E94

      I want to perform this action in Qlikview script and my data is in qvd format.

       

      Thanks in advance for the answers.