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.