topic Forecast in Qliksense in App Development https://community.qlik.com/t5/App-Development/Forecast-in-Qliksense/m-p/1651892#M48633 <P>Hello</P><P>I am looking for forecast in Qliksense. We have data of ticketing system which get logged everyday. Data is from JAN-19 to NOV-19 as below</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><TABLE><TBODY><TR><TD><STRONG>tick_num</STRONG></TD><TD><STRONG>EXTRACTDATE</STRONG></TD><TD><STRONG>Month-Year</STRONG></TD></TR><TR><TD>TKTC43680038</TD><TD>01-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43679855</TD><TD>01-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43674879</TD><TD>01-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43694599</TD><TD>02-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43694844</TD><TD>02-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43692921</TD><TD>02-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43687443</TD><TD>02-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43715566</TD><TD>03-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43714367</TD><TD>03-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43712006</TD><TD>03-01-2019</TD><TD>Jan-2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I used below formula to calculate forecast.</P><P><FONT color="#000000">=if(Count(tick_num),Count(tick_num), linest_m(total aggr(if(Count(tick_num),Count(tick_num)),[EXTRACTDATE.autoCalendar.YearMonth]),[EXTRACTDATE.autoCalendar.YearMonth])*</FONT></P><P><FONT color="#000000">only({1}[EXTRACTDATE.autoCalendar.YearMonth]) +linest_b(total aggr(if(Count(tick_num),Count(tick_num)),[EXTRACTDATE.autoCalendar.YearMonth]),[EXTRACTDATE.autoCalendar.YearMonth]))</FONT></P><P>&nbsp;</P><P><FONT color="#000000">After DEC-19 , I am getting the forecast values in minus as below. Is their anything wrong I am doing in above formula as I m getting minus values in forecast. Please help me. Thanks in advance.</FONT></P><TABLE><TBODY><TR><TD>Jan-2019</TD><TD>3215</TD></TR><TR><TD>Feb-2019</TD><TD>2574</TD></TR><TR><TD>Mar-2019</TD><TD>2857</TD></TR><TR><TD>Apr-2019</TD><TD>3053</TD></TR><TR><TD>May-2019</TD><TD>3180</TD></TR><TR><TD>Jun-2019</TD><TD>2120</TD></TR><TR><TD>Jul-2019</TD><TD>1176</TD></TR><TR><TD>Aug-2019</TD><TD>853</TD></TR><TR><TD>Sep-2019</TD><TD>899</TD></TR><TR><TD>Oct-2019</TD><TD>875</TD></TR><TR><TD>Nov-2019</TD><TD>759</TD></TR><TR><TD>Dec-2019</TD><TD>244.65148717654</TD></TR><TR><TD>Jan-2020</TD><TD>-46.375797834771</TD></TR><TR><TD>Feb-2020</TD><TD>-337.40308284614</TD></TR><TR><TD>Mar-2020</TD><TD>-609.65441398579</TD></TR><TR><TD>Apr-2020</TD><TD>-900.6816989971</TD></TR><TR><TD>May-2020</TD><TD>-1182.3210070726</TD></TR><TR><TD>Jun-2020</TD><TD>-1473.3482920839</TD></TR></TBODY></TABLE><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> Wed, 27 Nov 2019 13:22:16 GMT jshashiv 2019-11-27T13:22:16Z Forecast in Qliksense https://community.qlik.com/t5/App-Development/Forecast-in-Qliksense/m-p/1651892#M48633 <P>Hello</P><P>I am looking for forecast in Qliksense. We have data of ticketing system which get logged everyday. Data is from JAN-19 to NOV-19 as below</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><TABLE><TBODY><TR><TD><STRONG>tick_num</STRONG></TD><TD><STRONG>EXTRACTDATE</STRONG></TD><TD><STRONG>Month-Year</STRONG></TD></TR><TR><TD>TKTC43680038</TD><TD>01-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43679855</TD><TD>01-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43674879</TD><TD>01-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43694599</TD><TD>02-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43694844</TD><TD>02-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43692921</TD><TD>02-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43687443</TD><TD>02-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43715566</TD><TD>03-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43714367</TD><TD>03-01-2019</TD><TD>Jan-2019</TD></TR><TR><TD>TKTC43712006</TD><TD>03-01-2019</TD><TD>Jan-2019</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I used below formula to calculate forecast.</P><P><FONT color="#000000">=if(Count(tick_num),Count(tick_num), linest_m(total aggr(if(Count(tick_num),Count(tick_num)),[EXTRACTDATE.autoCalendar.YearMonth]),[EXTRACTDATE.autoCalendar.YearMonth])*</FONT></P><P><FONT color="#000000">only({1}[EXTRACTDATE.autoCalendar.YearMonth]) +linest_b(total aggr(if(Count(tick_num),Count(tick_num)),[EXTRACTDATE.autoCalendar.YearMonth]),[EXTRACTDATE.autoCalendar.YearMonth]))</FONT></P><P>&nbsp;</P><P><FONT color="#000000">After DEC-19 , I am getting the forecast values in minus as below. Is their anything wrong I am doing in above formula as I m getting minus values in forecast. Please help me. Thanks in advance.</FONT></P><TABLE><TBODY><TR><TD>Jan-2019</TD><TD>3215</TD></TR><TR><TD>Feb-2019</TD><TD>2574</TD></TR><TR><TD>Mar-2019</TD><TD>2857</TD></TR><TR><TD>Apr-2019</TD><TD>3053</TD></TR><TR><TD>May-2019</TD><TD>3180</TD></TR><TR><TD>Jun-2019</TD><TD>2120</TD></TR><TR><TD>Jul-2019</TD><TD>1176</TD></TR><TR><TD>Aug-2019</TD><TD>853</TD></TR><TR><TD>Sep-2019</TD><TD>899</TD></TR><TR><TD>Oct-2019</TD><TD>875</TD></TR><TR><TD>Nov-2019</TD><TD>759</TD></TR><TR><TD>Dec-2019</TD><TD>244.65148717654</TD></TR><TR><TD>Jan-2020</TD><TD>-46.375797834771</TD></TR><TR><TD>Feb-2020</TD><TD>-337.40308284614</TD></TR><TR><TD>Mar-2020</TD><TD>-609.65441398579</TD></TR><TR><TD>Apr-2020</TD><TD>-900.6816989971</TD></TR><TR><TD>May-2020</TD><TD>-1182.3210070726</TD></TR><TR><TD>Jun-2020</TD><TD>-1473.3482920839</TD></TR></TBODY></TABLE><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV> Wed, 27 Nov 2019 13:22:16 GMT https://community.qlik.com/t5/App-Development/Forecast-in-Qliksense/m-p/1651892#M48633 jshashiv 2019-11-27T13:22:16Z