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?
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
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
.png "Former Employee"){kind=icon}
