Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

New Contributor II

Calculate Rolling Average Hours for 30 weeks

I have the following columns in my data model:


I have to calculate the rolling average of hours a resource has spent on a particular project over last 30 weeks.

I found some solutions online but I'm not able to use them for my requirement.

Since I have date/month/quarter/year filters in my dashboard, should I be calculating the rolling average at app level or script level?

Any help will be appreciated!



Community Browser