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

       

       

      ........

       

      Thanks,

      Joshi

       

      please find the Excel data,Qvf application  file