Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I want to display the average of the 3rd and 4th rank values per branch.
The ranking is done per period for the branch.
My current formula works fine if I select a specific branch, but I want to display the average per branch without selecting a branch.
I.e. the last column needs to display 10.5 for branch ‘03‘ and 7.5 for branch ‘02’. See example.
You could use something like this:
https://community.qlik.com/t5/New-to-QlikView/How-to-calculate-who-the-top-customer-is/td-p/325809
and change the number of the rank depending on which rank do you want to show (maybe using ColumnNo()?)
Some other similar questions you may find useful:
You could use something like this:
https://community.qlik.com/t5/New-to-QlikView/How-to-calculate-who-the-top-customer-is/td-p/325809
and change the number of the rank depending on which rank do you want to show (maybe using ColumnNo()?)
Some other similar questions you may find useful: