Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
CorrieStadler
Contributor
Contributor

Average of ranked values

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.

CorrieStadler_0-1592329065157.pngCorrieStadler_1-1592329077498.png

 

 

1 Solution
1 Reply