Rolling data

[Victor_Alumanah]

Hello Experts,

I need some help, I have had a look around the forum but have not been able to find a solution I can tailor to fit my current issue.  I have a bar chart that displays some sales data in financial quarters, this means I have data for Q1, Q2, a little for Q3 and nothing for Q4.  I would like Q3 and Q4 to show a rolling 3 month average for the future dates that we do not yet have data for, if the Dimension "Type" = "Forecast".  Thanks in advance for your help. 

[Brett_Bleess]

Hey Victor, thanks for helping out on some of the other posts you have been answering!  I may have a couple of things here that could help, but I am not sure, hopefully they may give you a point in the right direction on things:

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

https://community.qlik.com/t5/Qlik-Design-Blog/The-Above-Function/ba-p/1465357

https://community.qlik.com/t5/Qlik-Design-Blog/Accumulations/ba-p/1466581

There may be some others in the Design Blog area as well, here is the base URL from which you can search yourself:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett