Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.