topic How to apply aggregate function on Latest/ Last Updated Entry of a table in QlikView https://community.qlik.com/t5/QlikView/How-to-apply-aggregate-function-on-Latest-Last-Updated-Entry-of/m-p/1406415#M425812 <HTML><HEAD></HEAD><BODY><P>I have a table that stores semester GPA and Cumulative GPA of a student. After every semester an entry of semester GPA and updated <SPAN style="font-size: 13.3333px;">Cumulative </SPAN>GPA is added in that table. So if a student has completed five semesters then there will be 5 entries in that table. </P><P></P><P>I need to get latest semester GPA and <SPAN style="font-size: 13.3333px;">Cumulative </SPAN><SPAN style="font-size: 13.3333px;">GPA of all students and then want to get their AVG, MAX, MIN, STDEV. Can someone help? </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">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.&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P></BODY></HTML> Fri, 06 Oct 2017 06:44:29 GMT 2017-10-06T06:44:29Z How to apply aggregate function on Latest/ Last Updated Entry of a table https://community.qlik.com/t5/QlikView/How-to-apply-aggregate-function-on-Latest-Last-Updated-Entry-of/m-p/1406415#M425812 <HTML><HEAD></HEAD><BODY><P>I have a table that stores semester GPA and Cumulative GPA of a student. After every semester an entry of semester GPA and updated <SPAN style="font-size: 13.3333px;">Cumulative </SPAN>GPA is added in that table. So if a student has completed five semesters then there will be 5 entries in that table. </P><P></P><P>I need to get latest semester GPA and <SPAN style="font-size: 13.3333px;">Cumulative </SPAN><SPAN style="font-size: 13.3333px;">GPA of all students and then want to get their AVG, MAX, MIN, STDEV. Can someone help? </SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">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.&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P></BODY></HTML> Fri, 06 Oct 2017 06:44:29 GMT https://community.qlik.com/t5/QlikView/How-to-apply-aggregate-function-on-Latest-Last-Updated-Entry-of/m-p/1406415#M425812 2017-10-06T06:44:29Z