Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-02-01 01:28 AM

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.

4,114 Views
0 Likes
11 Replies
lironbaram
Partner - Master III
Partner - Master III
‎2018-02-01 05:29 AM

In response to Anonymous

hi

look at this file

Test.qvw
450 Views
0 Likes
QS21
Creator
Creator
‎2022-07-18 01:51 AM

In response to lironbaram

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

363 Views
0 Likes