topic Forecast chart - dimension problem? in QlikView https://community.qlik.com/t5/QlikView/Forecast-chart-dimension-problem/m-p/392941#M560226 <HTML><HEAD></HEAD><BODY><P>Hi All!</P><P>I am beginner in QV. </P><P>Now I do not understand way to make forecast model in my case.</P><P>There is data includes money amount per month for 2-year period (its synthetic data, period in input data may vary).</P><P>The requested result of the model is getting forecast chart. Forecast period is 1 year, and chart must be calculated on a basis of trend line (y=bx+a) and average money amount per months for vary period (1 year, 2 year, 1 year 2 months etc.).</P><P>I made chart calculating trend line (get a and b coefficients). But dimension of this chart is real months for each year. When I trying change dimension to month (to calculate average values of amount) - trend line coefficients changed. As result, my chart is work correctly for 1 basis year. When more than 1 year is selected, trend line calculating is wrong.</P><P>Model is attached.</P><P>P.S. Sorry for my english<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thanks!</P></BODY></HTML> Wed, 24 Apr 2013 07:08:30 GMT 2013-04-24T07:08:30Z Forecast chart - dimension problem? https://community.qlik.com/t5/QlikView/Forecast-chart-dimension-problem/m-p/392941#M560226 <HTML><HEAD></HEAD><BODY><P>Hi All!</P><P>I am beginner in QV. </P><P>Now I do not understand way to make forecast model in my case.</P><P>There is data includes money amount per month for 2-year period (its synthetic data, period in input data may vary).</P><P>The requested result of the model is getting forecast chart. Forecast period is 1 year, and chart must be calculated on a basis of trend line (y=bx+a) and average money amount per months for vary period (1 year, 2 year, 1 year 2 months etc.).</P><P>I made chart calculating trend line (get a and b coefficients). But dimension of this chart is real months for each year. When I trying change dimension to month (to calculate average values of amount) - trend line coefficients changed. As result, my chart is work correctly for 1 basis year. When more than 1 year is selected, trend line calculating is wrong.</P><P>Model is attached.</P><P>P.S. Sorry for my english<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Thanks!</P></BODY></HTML> Wed, 24 Apr 2013 07:08:30 GMT https://community.qlik.com/t5/QlikView/Forecast-chart-dimension-problem/m-p/392941#M560226 2013-04-24T07:08:30Z