Discussion board where members can get started with QlikView.
The above sample data should be plotted in a Line Chart in way values sum up for each day. More like a Fibonacci series.
This should be my resultant table data
Is there a way to do this? Solutions for both at the script level or front end level (Using Expressions) would do the need.
Check this thread Cumulative sum depends on dimension values | Qlik Community
Using Straight Table
Take Dimension --> Category, Date
And Second Expression, If you have more Category, Dates then for safety you can give Value like below
For Ref, PFA
How long does accumulation restarts at the end of the month of end of the year? I am guessing it does restart for each category, right?
one front end solution could be the chart-in-built accumulation option:
hope this helps