8 Replies Latest reply: Mar 27, 2017 11:11 AM by Peter Cammaert RSS

    Qlik Sense Rank Calculation in Pivot table

    joshi Babu Are

      Hi Guru's,


      i have data like Employee sales amount by Product.


      i want to create rank column(Expression) based on the Total amount .


      How to achieve this.


      Iam using JS Pivot extension but not allowing me to write Second Expression.


      Example Output


      EmployeeNameProductTotal           Rank

      hhhhhhh                 P1                        5000              1

      djsdjcsjd                 P2                         4000            2








      please find the Excel data,Qvf application  file