Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
djbloiss
New Contributor III

Sum all values up to date

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])

Labels (2)
2 Replies
cbushey1
Contributor III

Re: Sum all values up to date

I was going to post an option for you but came across this community post that I think details what you want to do.

https://community.qlik.com/t5/QlikView-App-Development/set-analysis-YTD-calculation/td-p/800830

 

MindaugasBacius
Valued Contributor III

Re: Sum all values up to date