How can I create predictive or forecasting Analysis

[#1]

Hi all,

Is it possible to create forecast analysis for 2015 with QV ?

Sample Data:

LOAD * INLINE [

Year, Month, Value

2014, 1, 100

2014, 2, 500

...

2015, 1, 50

2015, 2, 100

];

How qv can create others months 3,4,5,6,7,8,9,10,11,12 for the forecasting 2015 ?

Thanks for your help.

[Anonymous]

Hi judikael,

Please select month dimension in straight chart.

Regards

Neetha

[#3]

Neetha,

I select the dimension but when I select 2015 year I only can see Jan and Feb not 12 months.

Thanks.

[Anonymous]

Hi Judikael,

Once you populate data for these months in 2015 you can see  months in straight table for selection of year 2015

[Anonymous · Accepted solution]

Hi,

Use below logic in script to populate data for req months:

Load Year,Month,
If( IsNull( sales ), Peek( Sales ),Sales ) as Sales
Resident Sales
Order By Year,Month;

[#6]

Thank you very much Neetha P. for your help.

[#7]

Hi Neetha,

I tried to use the forecasting with the method Inputfiled. It work fine

I would like to test your suggestion to compare but I don't know how can I realize it.

" You can create a calculated field in your load statement where you take the total, say, for the last 14 months(from Jan to 2015 feb), then divide it by the number of days  for 14 months and you will get a daily average. You then multiply that daily by the number of days for each month (i.e next 10 month) and you get the forecast for others months 3,4,5,6,7,8,9,10,11,12 for the forecasting 2015 ".

The goal is to have Active for next 10 months (3,4,5,6,7,8,9,10,11,12 ) ,Termination for next 10 months (3,4,5,6,7,8,9,10,11,12 )

and finally calculate the To for next 10  months (3,4,5,6,7,8,9,10,11,12 ) where To is Sum(Termination) / ( Sum(Active) / Count(distinct CalendarDate) ).

Thanks for your help.

[Anonymous]

Hi Judikael,

Can you copy paste your code here as i am using personnel edition.

attach sample data please.

Regards

Neetha

[#9]

Hi Neetha,

TEMP:
LOAD * INLINE [
Year,MonthNum,CalendarDate,Active,Termination
2014,1,41641,5 435,0
2014,1,41643,5 449,0
2014,1,41644,5 449,0
2014,1,41650,5 515,0
2014,1,41651,5 515,0
2014,1,41657,5 552,0
2014,1,41658,5 552,0
2014,1,41664,5 633,0
2014,1,41665,5 635,0
2014,1,41640,5 423,1
2014,1,41655,5 550,1
2014,1,41666,5 644,1
2014,1,41669,5 683,1
2014,1,41642,5 449,2
2014,1,41645,5 454,2
2014,1,41647,5 489,2
2014,1,41648,5 508,2
2014,1,41649,5 515,2
2014,1,41654,5 551,2
2014,1,41656,5 552,2
2014,1,41661,5 601,2
2014,1,41667,5 655,2
2014,1,41668,5 671,2
2014,1,41652,5 527,3
2014,1,41662,5 620,3
2014,1,41663,5 633,3
2014,1,41646,5 471,4
2014,1,41653,5 540,4
2014,1,41660,5 583,4
2014,1,41659,5 564,5
2014,1,41670,5 632,59
2015,1,42022,7 136,0
2015,1,42029,7 279,0
2015,1,42030,7 318,0
2015,1,42006,6 932,1
2015,1,42008,6 927,1
2015,1,42009,6 928,1
2015,1,42016,6 968,1
2015,1,42023,7 182,1
2015,1,42024,7 237,1
2015,1,42015,6 934,2
2015,1,42017,7 046,2
2015,1,42018,7 092,2
2015,1,42028,7 279,2
2015,1,42033,7 428,2
2015,1,42014,6 936,3
2015,1,42032,7 380,3
2015,1,42005,6 933,4
2015,1,42007,6 928,4
2015,1,42011,6 937,4
2015,1,42012,6 936,4
2015,1,42013,6 939,4
2015,1,42021,7 136,4
2015,1,42027,7 281,4
2015,1,42031,7 348,4
2015,1,42019,7 131,5
2015,1,42020,7 140,5
2015,1,42026,7 283,5
2015,1,42010,6 931,6
2015,1,42025,7 282,6
2015,1,42034,7 433,9
2015,1,42035,7 372,61];


LOAD
Year,
Num(Sum(Active) /30 ,'# ##0') as TotalActive,
Num(Sum(Termination) / 30,'# ##0') as TotalTermination
RESIDENT TEMP
GROUP BY Year;

DROP TABLE TEMP;

See attachment,

Thanks,

[#10]

Hi Neetha,

Have you look around my sample data ?

Thanks