Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Forecast chart - dimension problem?

Hi All!

I am beginner in QV.

Now I do not understand way to make forecast model in my case.

There is data includes money amount per month for 2-year period (its synthetic data, period in input data may vary).

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

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.

Model is attached.

P.S. Sorry for my english


Community Browser