Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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