Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
roy_fredericks
Contributor
Contributor

Creating dummy dates in date field

I have a set of dates and a value against these. What i want to do is create a forecasted trend lines for the weeks ahead based on an average of the last 3 weeks.

Please see data attached. The dates in red are the dates I want to generate and the value for these will be an average of the last 3 values. So the forecasted scroe for row 18 should be an average of 5.6 + 5.9 + 5.9.

Thank you

0 Replies