Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to get TOP 3 and Bottom 3 AVG and Max Difference value with rank function and AGGR.

We are having the requirement of top 3 and Bottom 3 avg of value.

Max of difference of Avg of top 3 and bottom 3.

11 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

look at this file

QS21
Contributor III
Contributor III

Hi I am unable to view this solution (QVW), could u post  the logic in comments pls?