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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
jshashiv
Contributor
Contributor

Forecast in Qliksense

Hello

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

 
tick_numEXTRACTDATEMonth-Year
TKTC4368003801-01-2019Jan-2019
TKTC4367985501-01-2019Jan-2019
TKTC4367487901-01-2019Jan-2019
TKTC4369459902-01-2019Jan-2019
TKTC4369484402-01-2019Jan-2019
TKTC4369292102-01-2019Jan-2019
TKTC4368744302-01-2019Jan-2019
TKTC4371556603-01-2019Jan-2019
TKTC4371436703-01-2019Jan-2019
TKTC4371200603-01-2019Jan-2019

 

I used below formula to calculate forecast.

=if(Count(tick_num),Count(tick_num), linest_m(total aggr(if(Count(tick_num),Count(tick_num)),[EXTRACTDATE.autoCalendar.YearMonth]),[EXTRACTDATE.autoCalendar.YearMonth])*

only({1}[EXTRACTDATE.autoCalendar.YearMonth]) +linest_b(total aggr(if(Count(tick_num),Count(tick_num)),[EXTRACTDATE.autoCalendar.YearMonth]),[EXTRACTDATE.autoCalendar.YearMonth]))

 

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.

Jan-20193215
Feb-20192574
Mar-20192857
Apr-20193053
May-20193180
Jun-20192120
Jul-20191176
Aug-2019853
Sep-2019899
Oct-2019875
Nov-2019759
Dec-2019244.65148717654
Jan-2020-46.375797834771
Feb-2020-337.40308284614
Mar-2020-609.65441398579
Apr-2020-900.6816989971
May-2020-1182.3210070726
Jun-2020-1473.3482920839
 
0 Replies