Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
rolling month in qliksense - set analysis
Here two guides:
HOW TO GET ROLLING MONTH USING SET ANALYSIS IN QLIK
The Magic of Set Analysis – Point In Time Reporting
refer existing articles
You could try an expression like this. (Assuming you expression is Sum(Amount),
sum(aggr(rangesum(above(total sum({<YearMonth=,Month=,Year=,Date= /*All date fields must be ignored/listed here*/>} Amount),0,12)),YearMonth))
Another approach is to create an as-of table. Take a look at HICs old blog post: "The As-of-table". It is a quite good approach for enabling R12 calculations.
https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130