How to aggregate data to the max date - Qlik Community

syaorose · ‎2019-09-27

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.

Thanks in advance for the help!

Vegar · ‎2019-09-28

Try set analys. Try this.

Sum({<DateField={"<=$(=max(DateField))"}>}Amount)

Vegar
Qlik Community MVP

Brett_Bleess · ‎2019-10-08

Just tossing out some Design Blog posts related to Set Analysis as well in case you may need the extra help/examples:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Here is the base Design Blog URL too in case you want to search around yourself for other posts:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.