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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlik Sense Forecasting

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:

if(SUM(Revenue),SUM(Revenue),

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

only({1}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?

Thanks!

0 Replies