0 Replies Latest reply: Dec 29, 2017 5:19 AM by Johan Boshoff RSS

    Ranking province or product based in measures in Du Pont Analysis

    Johan Boshoff

      Hi Guys,

       

      I' trying to replicate I did in Excel where I ranked all financial products in a specific province and also all provinces in terms of one financial products based on their performance in a specific measure (line item) in a Du Pont analysis. Then I created a radar chart using these rankings.

       

      I have a Du Pont Analysis set up for my by an advanced Qlik user but the syntax behind the measures are quite complex and I don't understand how to apply the rank function to these.

       

      Below the Du Pont table:

       

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

       

      Thank you kindly and happy holidays!

      Johan Boshoff