I am looking for guidance with a sum and timestamp within a set analysis or other suggestion.
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.
I am looking to calculate this continuously as a sum of that balance.
Basically, today balance = sum({<BALANCE_TIME={"<=$(MAX(BALANCE_TIME))"}>}BALANCE)
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.
Everything not saved will be lost
— Nintendo Quit screen message