Rolling data

Victor_Alumanah — Wed, 06 Nov 2019 10:14:08 GMT

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.

Re: Rolling data

Brett_Bleess — Tue, 12 Nov 2019 13:37:51 GMT

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

topic Rolling data in QlikView

Rolling data

Re: Rolling data