Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Aggr meed help

HI friends

i have a table student with two columns student id and marks.

Data set as shown below

student id.   Marks

15.                42

14.                39

13,                 22

11,               18

10.              90

9.                72

8.              33

7.              43

6.             11

5.              17

4.            38

3          66

2.       74

1,     10

now i wanted so consider latest 11 points i.e frpm15 to 5

then i need average of top 5 and avg of last six that

3 Replies
sunny_talwar

You need this in a text box object?

sunny_talwar

May be this in a text box object

For Top 5

=Avg(Aggr(If(Rank(If(Rank([student id]) <= 10, Marks)) <= 5, Marks), [student id]))

For Bottom 5

=Avg(Aggr(If(Rank(If(Rank([student id]) <= 10, Marks)) > 5, Marks), [student id]))

NOTE: 15 to 5 are just 10 data points so I used Bottom 5 instead of bottom 6 here

Anonymous
Not applicable
Author

‌yes