topic Aggr Question in QlikView https://community.qlik.com/t5/QlikView/Aggr-Question/m-p/697961#M252070 <HTML><HEAD></HEAD><BODY><P>Good afternoon All, I am having an issue with AGGR which I am hoping you will assist with. I need to place a value in a Text Object. The below expression works, but returns the result for every Task_ID. The Task_ID’s are numeric and will always be in sequential order. I only need the Amount for the max Task_ID. =aggr( sum( if(Effective_Date = '2010-01-01 00:00', Amount)), Task_ID ) I need to only sum the Amount for the Max(Task_ID). I am trying the below expression, but is does not return any value. =aggr( sum( max(if(Effective_Date = '2010-01-01 00:00', [Loan Disbursement Amount]), Task_ID)), Task_ID ) Regards, John</P></BODY></HTML> Wed, 02 Jul 2014 13:13:09 GMT johngouws 2014-07-02T13:13:09Z Aggr Question https://community.qlik.com/t5/QlikView/Aggr-Question/m-p/697961#M252070 <HTML><HEAD></HEAD><BODY><P>Good afternoon All, I am having an issue with AGGR which I am hoping you will assist with. I need to place a value in a Text Object. The below expression works, but returns the result for every Task_ID. The Task_ID’s are numeric and will always be in sequential order. I only need the Amount for the max Task_ID. =aggr( sum( if(Effective_Date = '2010-01-01 00:00', Amount)), Task_ID ) I need to only sum the Amount for the Max(Task_ID). I am trying the below expression, but is does not return any value. =aggr( sum( max(if(Effective_Date = '2010-01-01 00:00', [Loan Disbursement Amount]), Task_ID)), Task_ID ) Regards, John</P></BODY></HTML> Wed, 02 Jul 2014 13:13:09 GMT https://community.qlik.com/t5/QlikView/Aggr-Question/m-p/697961#M252070 johngouws 2014-07-02T13:13:09Z Re: Aggr Question https://community.qlik.com/t5/QlikView/Aggr-Question/m-p/697962#M252071 <HTML><HEAD></HEAD><BODY><P>Try FirstSortedValue(aggr(sum(Amount),Task_ID), -Task_ID)</P></BODY></HTML> Wed, 02 Jul 2014 13:29:09 GMT https://community.qlik.com/t5/QlikView/Aggr-Question/m-p/697962#M252071 Gysbert_Wassenaar 2014-07-02T13:29:09Z Re: Aggr Question https://community.qlik.com/t5/QlikView/Aggr-Question/m-p/697963#M252072 <HTML><HEAD></HEAD><BODY><P>Have you tried something like this:</P><P>=sum(aggr(max(if(Effective_Date='2010-01-01 00:00',Task_ID)),[Loan Disbursement Amount]))</P></BODY></HTML> Wed, 02 Jul 2014 13:53:51 GMT https://community.qlik.com/t5/QlikView/Aggr-Question/m-p/697963#M252072 Greg_Williams 2014-07-02T13:53:51Z