Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
panwipa2528
Contributor III
Contributor III

How do I create forecast chart for view 3 months in the future (Jan-Mar 2018)?

If I have data sale from 2016-2017 as below, How do I create forecast chart for view 3 months in the future (Jan-Mar 2018)?

 

YearMonthSale
20160151,430
20160288,265
20160380,294
20160477,470
20160577,790
20160682,874
20160779,558
20160875,460
20160969,899
20161071,511
20161187,371
201612102,744
20170167,424
20170278,588
20170390,834
20170485,888
20170576,152
20170674,970
20170782,990
20170880,470
20170982,600
20171067,080
20171182,221
20171238,686
2 Replies
Anil_Babu_Samineni

May be this?

Left(YearMonth,4) as Year

Expression should be this?

if(Year<>'2017',sum(Sale), Linest_m(total aggr(if(sum(Sale),sum(Sale)),Year),Year)*Year+Linest_b(total aggr(if(sum(Sale),sum(Sale)),Year),Year))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

What are the expected numbers you hope to see for the future months? Is this something you need in the script or on the front end?