topic Max Aggr in QlikView https://community.qlik.com/t5/QlikView/Max-Aggr/m-p/661678#M1069000 <HTML><HEAD></HEAD><BODY><P>I really dont understand the max aggr function and I think i need it.</P><P>I have a series of budget amounts entered into our system and I only want to show the most recent one</P><P></P><P><STRONG>Project&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Timestamp&nbsp;&nbsp;&nbsp;&nbsp; Budget</STRONG></P><P>Finance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; £25,000</P><P>Finance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; £30,000</P><P>Finance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; £20,000</P><P>Finance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; £23,000</P><P></P><P>So I want to show the budget amount for only the most recent entry (ie the one against timestamp 4 in this case = £23,000)</P><P></P><P>Any helpers out there?</P></BODY></HTML> Wed, 27 Aug 2014 13:01:55 GMT Karl_Hart 2014-08-27T13:01:55Z Max Aggr https://community.qlik.com/t5/QlikView/Max-Aggr/m-p/661678#M1069000 <HTML><HEAD></HEAD><BODY><P>I really dont understand the max aggr function and I think i need it.</P><P>I have a series of budget amounts entered into our system and I only want to show the most recent one</P><P></P><P><STRONG>Project&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Timestamp&nbsp;&nbsp;&nbsp;&nbsp; Budget</STRONG></P><P>Finance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; £25,000</P><P>Finance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; £30,000</P><P>Finance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; £20,000</P><P>Finance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; £23,000</P><P></P><P>So I want to show the budget amount for only the most recent entry (ie the one against timestamp 4 in this case = £23,000)</P><P></P><P>Any helpers out there?</P></BODY></HTML> Wed, 27 Aug 2014 13:01:55 GMT https://community.qlik.com/t5/QlikView/Max-Aggr/m-p/661678#M1069000 Karl_Hart 2014-08-27T13:01:55Z Re: Max Aggr https://community.qlik.com/t5/QlikView/Max-Aggr/m-p/661679#M1069001 <HTML><HEAD></HEAD><BODY><P>=FirstSortedValue(Budget,-Timestamp)</P></BODY></HTML> Wed, 27 Aug 2014 13:04:25 GMT https://community.qlik.com/t5/QlikView/Max-Aggr/m-p/661679#M1069001 MK_QSL 2014-08-27T13:04:25Z Re: Max Aggr https://community.qlik.com/t5/QlikView/Max-Aggr/m-p/661680#M1069002 <HTML><HEAD></HEAD><BODY><P>Thanks Manish, that was simpler than expected</P></BODY></HTML> Wed, 27 Aug 2014 13:10:03 GMT https://community.qlik.com/t5/QlikView/Max-Aggr/m-p/661680#M1069002 Karl_Hart 2014-08-27T13:10:03Z