Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Actual Vs Forecast

Hi All,

I have Actual Data which contains Report Date, Expected Close Date of an Issue and Issue ID(other columns for drill down as well). All my actuals are open Issues only for that month. Based on the actual data, using Expected Close Date I have to create next six months forecast.

Example expected close date between 9/1/2017 to 9/30/2017 I have to count the Issue and subtract from total count of issues.

For Oct I have to count Sep+Oct and subtract from total count. Like wise for all 6 months.

Required show the actual and forecast data in a line chart.

I have calculated next six month and relevant flag at load script.

But now I am confused as I have a actuals line chart for rolling 8 reporting dates and now I have to show this next six months as forecast.Second, How can I show difference between total and accumulative sum of each month.

Please suggest.

Thanks in advance.

0 Replies