Forecast Line Chart for Coming Month Sales

[anonymous1]

hi, 

I'm trying to create a forecast trend line, based on the avg sales of previous months. so, starting next month i would like the line to begin at the avg amount, and every month after that i would like to incrementally add the average to develop a trend line over time.  i.e. a loop would be ideal but not sure how this works in qlikview. does anyone have any ideas?

[Brett_Bleess]

About the best I have here is a link to the Design Blog area, hundreds of posts out there with examples of how to do different things:

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

Just use the search box to go looking for things.  I did look around, but I was not exactly sure for what you were looking, so I figured properly best to let you search for things directly.

Regards,
Brett