Discussion board where members can get started with QlikView.
I' have some simple data..months and sales.
How do I do a forecast, based on historical sales?
Any help would be appreciated
Look this thread:
FORECAST and TREND function of Excel in Qlik Sense
Juan P. Barroso
Is this valid for qlikView as well, as I'm working there and not Sense?
Yes it's valid
this seems to be really complicated...here is a copy of my App...
obviously I need to add addition months to my app...lets say 3 months. Not sure how to do that....
I found this really helpul..
I updated the subrutine of calendar to add 3 month, and I add a forecast line to chart.
thank you very much - would you please attach the Qvw?
Yes, here you are.
If I'm correct the change that you made was where I generated the calendar? this line
,addMonths(max(datefield),3) as DateMax
but how do I build the forecast line on the chart?