topic Get expression for latest date in QlikView https://community.qlik.com/t5/QlikView/Get-expression-for-latest-date/m-p/717338#M540133 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">ex. Loaded table</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P>Week, value</P><P>week 1, 2</P><P>week 1, 3</P><P>week 1, 1</P><P>week 2, 1</P><P>week 2, 3</P><P>week 3, 1</P><P>week 3, 2</P><P></P><P></P><P>I want to get : sum(value) for most recent week (i.e. "week 3"); I suspect a combination of aggr() and firstsortedvalue() should do the trick, but I can't nail it down.</P><P></P><P>Thanks for your help.</P></BODY></HTML> Mon, 21 Jul 2014 11:30:58 GMT Anonymous 2014-07-21T11:30:58Z Get expression for latest date https://community.qlik.com/t5/QlikView/Get-expression-for-latest-date/m-p/717338#M540133 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; line-height: 1.5em;">ex. Loaded table</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P>Week, value</P><P>week 1, 2</P><P>week 1, 3</P><P>week 1, 1</P><P>week 2, 1</P><P>week 2, 3</P><P>week 3, 1</P><P>week 3, 2</P><P></P><P></P><P>I want to get : sum(value) for most recent week (i.e. "week 3"); I suspect a combination of aggr() and firstsortedvalue() should do the trick, but I can't nail it down.</P><P></P><P>Thanks for your help.</P></BODY></HTML> Mon, 21 Jul 2014 11:30:58 GMT https://community.qlik.com/t5/QlikView/Get-expression-for-latest-date/m-p/717338#M540133 Anonymous 2014-07-21T11:30:58Z Re: Get expression for latest date https://community.qlik.com/t5/QlikView/Get-expression-for-latest-date/m-p/717339#M540134 <HTML><HEAD></HEAD><BODY><P>=Sum({&lt;Week={"$(=MaxString(<STRONG>{1}</STRONG>Week))"}&gt;} Value)</P></BODY></HTML> Mon, 21 Jul 2014 11:33:49 GMT https://community.qlik.com/t5/QlikView/Get-expression-for-latest-date/m-p/717339#M540134 tresB 2014-07-21T11:33:49Z Re: Get expression for latest date https://community.qlik.com/t5/QlikView/Get-expression-for-latest-date/m-p/717340#M540135 <HTML><HEAD></HEAD><BODY><P>Thanks, Set Analysis was the answer.</P></BODY></HTML> Mon, 21 Jul 2014 12:32:05 GMT https://community.qlik.com/t5/QlikView/Get-expression-for-latest-date/m-p/717340#M540135 Anonymous 2014-07-21T12:32:05Z