topic Re: How do I create forecast chart for view 3 months in the future (Jan-Mar 2018)? in QlikView https://community.qlik.com/t5/QlikView/How-do-I-create-forecast-chart-for-view-3-months-in-the-future/m-p/1373131#M419399 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Fri, 08 Dec 2017 13:31:18 GMT sunny_talwar 2017-12-08T13:31:18Z How do I create forecast chart for view 3 months in the future (Jan-Mar 2018)? https://community.qlik.com/t5/QlikView/How-do-I-create-forecast-chart-for-view-3-months-in-the-future/m-p/1373129#M419397 <HTML><HEAD></HEAD><BODY><P>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)?</P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 152px;"><TBODY><TR><TD class="xl67" height="17" width="76"><SPAN style="color: #ff0000;">YearMonth</SPAN></TD><TD class="xl68" style="border-left: none; text-align: center;" width="76"><SPAN style="color: #ff0000;">Sale</SPAN></TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201601</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">51,430</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201602</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">88,265</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201603</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">80,294</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201604</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">77,470</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201605</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">77,790</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201606</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">82,874</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201607</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">79,558</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201608</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">75,460</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201609</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">69,899</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201610</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">71,511</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201611</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">87,371</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201612</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">102,744</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201701</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">67,424</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201702</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">78,588</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201703</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">90,834</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201704</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">85,888</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201705</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">76,152</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201706</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">74,970</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201707</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">82,990</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201708</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">80,470</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201709</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">82,600</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201710</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">67,080</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201711</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">82,221</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">201712</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">38,686</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 08 Dec 2017 13:22:59 GMT https://community.qlik.com/t5/QlikView/How-do-I-create-forecast-chart-for-view-3-months-in-the-future/m-p/1373129#M419397 panwipa2528 2017-12-08T13:22:59Z Re: How do I create forecast chart for view 3 months in the future (Jan-Mar 2018)? https://community.qlik.com/t5/QlikView/How-do-I-create-forecast-chart-for-view-3-months-in-the-future/m-p/1373130#M419398 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P></P><P><SPAN style="color: #000000;"><STRONG>Left(<SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">YearMonth,4) as Year</SPAN></STRONG></SPAN></P><P></P><P>Expression should be this?</P><P style="font-size: 13px; font-family: 'helvetica neue', helvetica, arial, 'lucida grande', sans-serif; color: #3d3d3d;"><STRONG>if(Year&lt;&gt;'2017',sum(Sale), L</STRONG><STRONG>inest_m(total aggr(if(sum(<SPAN style="color: #3d3d3d; font-family: 'helvetica neue', helvetica, arial, 'lucida grande', sans-serif; font-size: 13px;">Sale</SPAN>),sum(<SPAN style="color: #3d3d3d; font-family: 'helvetica neue', helvetica, arial, 'lucida grande', sans-serif; font-size: 13px;">Sale</SPAN>)),Year),Year)*Year</STRONG><STRONG>+Linest_b(total aggr(if(sum(<SPAN>Sale</SPAN>),sum(<SPAN>Sale</SPAN>)),Year),Year))</STRONG></P></BODY></HTML> Fri, 08 Dec 2017 13:26:47 GMT https://community.qlik.com/t5/QlikView/How-do-I-create-forecast-chart-for-view-3-months-in-the-future/m-p/1373130#M419398 Anil_Babu_Samineni 2017-12-08T13:26:47Z Re: How do I create forecast chart for view 3 months in the future (Jan-Mar 2018)? https://community.qlik.com/t5/QlikView/How-do-I-create-forecast-chart-for-view-3-months-in-the-future/m-p/1373131#M419399 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Fri, 08 Dec 2017 13:31:18 GMT https://community.qlik.com/t5/QlikView/How-do-I-create-forecast-chart-for-view-3-months-in-the-future/m-p/1373131#M419399 sunny_talwar 2017-12-08T13:31:18Z