Calculating rolling n-period totals with missing periods
I've been researching how to implement in Qlik Sense what seems like a simple question on the surface but to date I have had no luck. I'm either overthinking it or simply way out of my depth on this one.
The problem is quite simple.
Given a sales event I wish to sum the sales occurring from that date within the next n periods. Could be 7 days, 1 month etc.
There are many dates, in this instance they relate to store visits, many customers and many sales.
In the data we are working with there may not be any sales within the date frame however there would be subsequent sales. Counting the next values using RangeSum() thus appear to not work or would likely give results calculated from outside the date range.
So at this point I am looking for a little guidance. Maybe I have already past the correct solution but haven't realized it or maybe there is a different area I should be looking. As always any direction would be appreciated.