topic Re: How can I create a predictive month and Week with Linest_m function ? in QlikView

How can I create a predictive month and Week with Linest_m function ?

Mon, 26 Jan 2015 21:22:04 GMT

Hi all,

I want to create a predictive month and week with the linest function Linest_m for the 2014 and 2015 year.

How can I achieve it ?

Thank for your help.

MarcoWedel — Mon, 26 Jan 2015 22:21:06 GMT

please describe your data and the result you are looking for.

regards

Marco

Tue, 27 Jan 2015 01:30:37 GMT

Hello Marco,

I have a sample table with

CalendarDate represents the day where the Emp_Id is active

Emp_Id is an employee Code

Termination is a flag who the employee left the enterprise

Hired is flag where the employee is active

I want to create a bar chart with my turnover expression for 2015 and MonthNum.

When I select 2015 year in bar chart I want to have the twelve months and my turnover expression.

If months don't exist then I calculate a forecasting turnover until end month for 2015.

jan. - 0.65%

feb. - forecasting To

mar. - forecasting To

apr. - forecasting To

may. - forecasting To

jun. - forecasting To

jul. - forecasting To

aug. - forecasting To

sept. - forecasting To

oct. - forecasting To

nov. - forecasting To

déc. - forecasting To

Is it possible to have this same chart by WeekNum ?

Thanks.

Thu, 29 Jan 2015 19:18:12 GMT

Hello Marco,

Have you enough information about the manner to calculate a forecasting month and week for 2015 ?