Cumulative sum over dimension in this year.

[Jozefswistak]

Hello. I'm new in Qlik, so I need a help. I try to do a cumulative sum in this way:
Dimension DayDate defines every single day. I also have a field where there is showed total quantity of production of every day, named Production.

I want to see, when I e.g. choose day 23rd Feb, the total sum of quantity of production from the beginning of the year until the 23rd Feb. I tried with range + sum + above, but I have to see all days 'till the chosen one, what is not what I want. I want to see only chosen day.
How can this be solved? Glad to see some help from You.

Thanks.

[ogster1974]

Do the calculation on script side when loading your data.

https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecor...

Load *,

(Quantity + Previous("Total Quantity") )as "Total Quantity"

Make sure your data is ordered by Date and any other appropriate dimension.