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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?