topic Average of ranked values in QlikView

Average of ranked values

CorrieStadler — Tue, 16 Jun 2020 17:51:42 GMT

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.

Re: Average of ranked values

Miguel_Angel_Baeyens — Wed, 17 Jun 2020 06:53:52 GMT

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: