Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

lornafnb
Valued Contributor

Forecast

hi guys

I' have some simple data..months and sales.

How do I do a forecast, based on historical sales?

Any help would be appreciated

thanks

16 Replies
jubarros
Contributor II

Re: Forecast

Hi Lorna:

Look this thread:

FORECAST and TREND function of Excel in Qlik Sense

Best Regards,

Juan P. Barroso

lornafnb
Valued Contributor

Re: Forecast

hello Juan,

Is this valid for qlikView as well, as I'm working there and not Sense?

jubarros
Contributor II

Re: Forecast

Yes it's valid

lornafnb
Valued Contributor

Re: Forecast

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....

pascos88
Contributor

Re: Forecast

Hi Lorna,

I found this really helpul..

Best

jubarros
Contributor II

Re: Forecast

Hi Lorna:

I updated the subrutine of calendar to add 3 month, and I add a forecast line to chart.

Best Regard,

Juan P. Barroso

lornafnb
Valued Contributor

Re: Forecast

Hello Juan,

thank you very much - would you please attach the Qvw?

Much appreciated

jubarros
Contributor II

Re: Forecast

Yes, here you are.

lornafnb
Valued Contributor

Re: Forecast

Hello Juan

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?