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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to apply aggregate function on Latest/ Last Updated Entry of a table

I have a table that stores semester GPA and Cumulative GPA of a student. After every semester an entry of semester GPA and updated Cumulative GPA is added in that table. So if a student has completed five semesters then there will be 5 entries in that table.

I need to get latest semester GPA and Cumulative GPA of all students and then want to get their AVG, MAX, MIN, STDEV. Can someone help?


I do not have a date field in this table but I have fields of term. An entry is added in the table against a term.    

0 Replies