To Show Rolling 3 Months Data

[sunitha_chellaiah]

Hi All,

I want to show rolling 3 months sales in straight table based on month selection.

For Eg. If I select June from filter then data should show June, May, April months sales value

I have only year and month field in the data. I don't have date field.

Please help to achieve this task.

Thanks

[rubenmarin]

Hi, one possible solution may be using an as-of calendar: https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130