Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

boshoffj
New Contributor II

Ranking province or product based in measures in Du Pont Analysis

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