0 Replies Latest reply: Feb 5, 2017 12:14 AM by Feras Alsuhaibani RSS

    Qlik Sense Forecasting

    Feras Alsuhaibani

      Hello everyone!


      Is there a way to forecast using Qlik Sense? We have a system that receives requests and every request has a certificate if it is approved; now what I would like to forecast is the number of submitted applications for this year, the number of certificates that are to be issued and the rejected applications. I came acorss some one that suggested I should be using something like the following:



      linest_m(total aggr(if(SUM(Revenue),SUM(Revenue)),Date),Date)*


      +linest_b(total aggr(if(SUM(Revenue),SUM(Revenue)),Date),Date))


      so can anyone please explain what this means? and does it actually do the forecasting?