topic Re: Rolling Totals in QlikView

Rolling Totals

fcecconi — Fri, 13 Nov 2015 14:10:12 GMT

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!

Re: Rolling Totals

sunny_talwar — Fri, 13 Nov 2015 14:21:14 GMT

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

Re: Rolling Totals

miguelbraga — Fri, 13 Nov 2015 14:50:51 GMT

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,