8 Replies Latest reply: Jan 4, 2018 7:01 AM by Sunny Talwar RSS

    Ranking products based on each line (measure) of a Du Pont Analysis

    Johan Boshoff

      Hi Guys,

       

      I have a pivot table for a Du Pont Analysis to allow me to look at performance of different products across a province/suit (geographical area).

       

      I run a similar exercise in Excel where I ranked the products in a single province, or provinces for a single product, from where I then created a radar diagram.

       

      Below the Du Pont analysis set up for me by an advanced Qlik user.

      Looking at the basic RANK-function I get confused as to how to apply it as the syntax behind every Du POnt measure is quite advanced for me.

       

      Please let me know what additional information I can provide to assist in creating a solution.

       

      Kind regards, and happy holidays.

      Johan