Average of ranked values

[CorrieStadler]

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.

[Miguel_Angel_Baeyens · Accepted solution]

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:

• https://community.qlik.com/t5/QlikView-App-Development/Display-top-5-and-the-rest-in-Others/td-p/310...
• https://community.qlik.com/t5/QlikView-App-Development/showing-max-in-text-box/m-p/267831
• https://community.qlik.com/t5/Qlik-Design-Blog/Don-t-get-aggr-avated-using-aggr/ba-p/1464136
• https://community.qlik.com/t5/New-to-QlikView/Avg-of-top-3/td-p/275808