Ranking province or product based in measures in Du Pont Analysis
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.