Rolling 12 months from each month year

[rekhagrramadas]

Hi All, I am new to Qliksense. I have a requirement of finding a rolling 12 months count of IDS for each month year. 

For Example: if I have April 2022, then the count should be taken from May 2021 to April 2022, for April 2021- should be from May 2020 to April 2021 and so on. 

I have tried different methods and none of them seems to be working, every result is just giiving the count of IDS for that particular month alone. 

Appreciate any small help!

[rubenmarin1]

Hi, if you have the previous months in the cahart you canuse the "modifier" option in the measure to acummulate last 12 values.

If you want the chart to show the 12M accumulation for each month without the need to show the 12 previous month in the chart you can use something similar to the asof table: https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130