Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
psenthilbtech
Contributor III
Contributor III

Qlik - Forecasting based on Previous Year Month Data

Hi, 

I have a scenario, where i have to forecast the data based on the last Year Month Data. Below is the sample data

Qn : With the given data below - i need to forecast the data for Sep-20 till Dec - 2020 (Based on the Months Previous Year Data)

Ex:  For Sept 2020 - I should get the value of Sept 2019, as i dont have the value for Sept 2018

For Oct  2020 - I should get the value of Oct 2019, as i dont have the value for OCt 2018

For Nov 2020 - I should get the Average value of Nov2019 and Nov 2018 and goes on

 

 

MonthPB
Nov-189041
Dec-189747
Jan-199243
Feb-197839
Mar-1913000950
Apr-1910621127
May-1911752534
Jun-1911144306
Jul-199192501
Aug-1910075416
Sep-197092894
Oct-195640611
Nov-194613950
Dec-194557715
Jan-204384742
Feb-204777633
Mar-207893871
Apr-204339084
May-204649449
Jun-205785399
Jul-204760955
Aug-204747258
Sep-20 
Oct-20 
Nov-20 
Dec-20

 

 

Labels (1)
1 Reply
Raied
Partner - Contributor
Partner - Contributor

soo were you able to find a solution for it?