https://community.qlik.com/t5/QlikView/Sum-all-previous-dates-to-today-with-timestamp/m-p/1695356#M450907 <P>I am looking for guidance with a sum and timestamp within a set analysis or other suggestion.</P><P>I have a daily report that needs to be brought into Qlik. This report runs daily at 1:59:59.9999999am and 2:00:00.0000000am. Essentially, End date and Start date respectively. Each day these deliver a balance from start date to end date of all previous days to date.</P><P>I am looking to calculate this continuously as a sum of that balance.</P><P>Basically, today balance = sum({&lt;BALANCE_TIME={"&lt;=$(MAX(BALANCE_TIME))"}&gt;}BALANCE)</P><P>However MAX() does not account for that start date. Is there a way to sum all previous dates up to today at 2am? In addition to going back each day at 2am? Option to do 1:59 today and previous days, too.</P> Sat, 16 Nov 2024 18:45:19 GMT SonOfJeffGoldblum 2024-11-16T18:45:19Z https://community.qlik.com/t5/QlikView/Sum-all-previous-dates-to-today-with-timestamp/m-p/1695356#M450907 <P>I am looking for guidance with a sum and timestamp within a set analysis or other suggestion.</P><P>I have a daily report that needs to be brought into Qlik. This report runs daily at 1:59:59.9999999am and 2:00:00.0000000am. Essentially, End date and Start date respectively. Each day these deliver a balance from start date to end date of all previous days to date.</P><P>I am looking to calculate this continuously as a sum of that balance.</P><P>Basically, today balance = sum({&lt;BALANCE_TIME={"&lt;=$(MAX(BALANCE_TIME))"}&gt;}BALANCE)</P><P>However MAX() does not account for that start date. Is there a way to sum all previous dates up to today at 2am? In addition to going back each day at 2am? Option to do 1:59 today and previous days, too.</P> Sat, 16 Nov 2024 18:45:19 GMT https://community.qlik.com/t5/QlikView/Sum-all-previous-dates-to-today-with-timestamp/m-p/1695356#M450907 SonOfJeffGoldblum 2024-11-16T18:45:19Z