Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Category | Date | Value |
---|---|---|
A | 01-Oct-2016 | 2 |
A | 02-Oct-2016 | 3 |
A | 03-Oct-2016 | 1 |
A | 04-Oct-2016 | 5 |
A | 05-Oct-2016 | 4 |
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
Category | Date | Value | NewValue |
---|---|---|---|
A | 01-Oct-2016 | 2 | 2 |
A | 02-Oct-2016 | 3 | 5 |
A | 03-Oct-2016 | 1 | 6 |
A | 04-Oct-2016 | 5 | 11 |
A | 05-Oct-2016 | 4 | 15 |
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
Perhaps this
Using Straight Table
Take Dimension --> Category, Date
Expressions are
1) Sum(Value)
2) Rangesum(Below(Sum(Value),0),Above(Value,1,4))
And Second Expression, If you have more Category, Dates then for safety you can give Value like below
Rangesum(Below(Sum(Value),0),Above(Value,1,1000))
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?
Hi,
one front end solution could be the chart-in-built accumulation option:
hope this helps
regards
Marco