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
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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: 
Not applicable
‎2017-10-06 02:44 AM

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.    

235 Views
0 Likes
0 Replies
Community Browser