I am trying to create a formula that will sum a field up to date for every date. So on January 1st it would just be January 1st, on January 2nd it would be the 1st and the 2nd, on January 3rd it would be the 1st, 2nd, and 3rd. I found how to do that just for today but I need it for every date. This is what I thought would work but as I tried it I realized it would only work with a variable and it would be impossible to have a variable for every date:
https://community.qlik.com/t5/QlikView-Layout-Visualizations/Sum-across-a-date-range/td-p/353821
This is what I have tried:
sum({$<[Account]={'2000'}, [Journal posting date]={'<='}>}[Transaction amount])
