https://community.qlik.com/t5/QlikView/Aggregate-function-not-working/m-p/1542012#M439510 Many Thanks Rubenmarin <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Sun, 10 Feb 2019 12:02:48 GMT Edge 2019-02-10T12:02:48Z https://community.qlik.com/t5/QlikView/Aggregate-function-not-working/m-p/1541987#M439505 <P>Hello.</P><P>I have a table that has multiple entries for each student for different information. but I want to find out the average GPA for these students excluding duplicate rows. The below expression doesn't work with me though:</P><P>aggr(DISTINCT Avg(RetentionModel.CumGPA),RetentionModel.EMPLID,RetentionModel.CumGPA)</P><P>Also, if I want to add set analysis like to exclude GPA of Zero, where in this expression can I do this?</P> Sun, 10 Feb 2019 09:44:49 GMT https://community.qlik.com/t5/QlikView/Aggregate-function-not-working/m-p/1541987#M439505 Edge 2019-02-10T09:44:49Z https://community.qlik.com/t5/QlikView/Aggregate-function-not-working/m-p/1542005#M439508 Hi, maybe with:<BR />Avg({&lt;RetentionModel.CumGPA-={0}&gt;} aggr(DISTINCT RetentionModel.CumGPA, RetentionModel.EMPLID,RetentionModel.CumGPA)) Sun, 10 Feb 2019 11:27:19 GMT https://community.qlik.com/t5/QlikView/Aggregate-function-not-working/m-p/1542005#M439508 rubenmarin 2019-02-10T11:27:19Z https://community.qlik.com/t5/QlikView/Aggregate-function-not-working/m-p/1542012#M439510 Many Thanks Rubenmarin <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Sun, 10 Feb 2019 12:02:48 GMT https://community.qlik.com/t5/QlikView/Aggregate-function-not-working/m-p/1542012#M439510 Edge 2019-02-10T12:02:48Z