Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to create a rolling total by month. I have found some great examples in the community, but unfortunately I am not getting my expected totals. This is the expression I am using: sum( aggr( rangesum( above( Count({<[Record OSHA Form]={'Yes'}>}[Date of Injury]),0,12) ),Safety_Month))
Safety_Month | Total # | Recorded # | Lost Time # | Running Sum | Running Sum (Correct) |
Jan 2015 | 1 | 1 | 0 | 1 | 1 |
Feb 2015 | 3 | 1 | 0 | 2 | 2 |
Mar 2015 | 4 | 2 | 0 | 4 | 4 |
Apr 2015 | 2 | 0 | 0 | 0 | 4 |
May 2015 | 1 | 0 | 0 | 0 | 4 |
Jun 2015 | 0 | 0 | 0 | 0 | 4 |
Jul 2015 | 0 | 0 | 0 | 0 | 4 |
Aug 2015 | 0 | 0 | 0 | 0 | 4 |
Sep 2015 | 0 | 0 | 0 | 0 | 4 |
Oct 2015 | 0 | 0 | 0 | 0 | 4 |
The last column is what I need the calculation to be.
thanks!
Hey Frank,
Please check this out:
Calculating rolling n-period totals, averages or other aggregations
Or watch this video:
QlikView | Expressions | Creating Running Total or Rolling n days total - YouTube
You may find it useful
Regards,
MB
We can recommend a solution for the data you have shared, but you might need to tweak that for your scenario or provide with a sample of what you are working with.
Best,
Sunny
Hey Frank,
Please check this out:
Calculating rolling n-period totals, averages or other aggregations
Or watch this video:
QlikView | Expressions | Creating Running Total or Rolling n days total - YouTube
You may find it useful
Regards,
MB