https://community.qlik.com/t5/QlikView/How-to-aggregate-data-to-the-max-date/m-p/1629282#M733444 <P>Try set analys. Try this.</P><P>Sum({&lt;DateField={"&lt;=$(=max(DateField))"}&gt;}Amount)</P> Sat, 28 Sep 2019 07:33:00 GMT Vegar 2019-09-28T07:33:00Z https://community.qlik.com/t5/QlikView/How-to-aggregate-data-to-the-max-date/m-p/1629254#M733443 <P>Hi all, would anyone be able to advise how Qlikview can automatically accumulate data from earliest date to the date gets selected. If there is no date selected, default to be the max date.</P><P>Thanks in advance for the help!</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-aggregate-data-to-the-max-date/m-p/1629254#M733443 syaorose 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/How-to-aggregate-data-to-the-max-date/m-p/1629282#M733444 <P>Try set analys. Try this.</P><P>Sum({&lt;DateField={"&lt;=$(=max(DateField))"}&gt;}Amount)</P> Sat, 28 Sep 2019 07:33:00 GMT https://community.qlik.com/t5/QlikView/How-to-aggregate-data-to-the-max-date/m-p/1629282#M733444 Vegar 2019-09-28T07:33:00Z https://community.qlik.com/t5/QlikView/How-to-aggregate-data-to-the-max-date/m-p/1632637#M733445 <P>Just tossing out some Design Blog posts related to Set Analysis as well in case you may need the extra help/examples:</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344</A></P> <P>Here is the base Design Blog URL too in case you want to search around yourself for other posts:</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog</A></P> <P>Regards,<BR />Brett</P> Tue, 08 Oct 2019 15:37:14 GMT https://community.qlik.com/t5/QlikView/How-to-aggregate-data-to-the-max-date/m-p/1632637#M733445 Brett_Bleess 2019-10-08T15:37:14Z