topic Re: Forecast shows only latest total in QlikView

Forecast shows only latest total

Wed, 08 Feb 2017 16:51:33 GMT

I have figured out somewhat how to use the forecast feature from other forum posts, but when i try to customize for my own situation, i'm having a problem. My project has 2 full prior years of data plus current YTD. My line chart uses month and year dimensions to show month over month accumulation, with each line representing a year.

When I turn on the forecast feature for the full dataset in my chart nothing happens - the line for current YTD stops at this month. So i tried doing an overlay, where one chart would show just the 2 full prior years, and another chart could lay over the top with the current YTD plus forecast, but when i do that, it projects a straight horizontal line out for the rest of the year with the same value instead of projecting based on the first 2 months of data.

Can anyone tell me what I'm missing? I want the current year line to project out to end of this year.

Re: Forecast shows only latest total

sunny_talwar — Wed, 08 Feb 2017 16:57:03 GMT

You seem to be doing full accumulation? How is that related to forecasting? What are the numbers you are hoping to see for the future months?

Re: Forecast shows only latest total

Wed, 08 Feb 2017 17:32:18 GMT

I'm doing full accumulation so the lines will show the running total by month over the course of the year. I want the forecasting to show what we project for end of year total. So if my number for January this year is 36,461, and so far in Feb I'm at 46,275, then based on that i can project something around 56K in March, 66K in April, etc.