topic Re: Forecasting in QlikView https://community.qlik.com/t5/QlikView/Forecasting/m-p/56240#M774260 <HTML><HEAD></HEAD><BODY><P>Hi Simon, sorry, but can you explain better. You just want to show the number of calls that you may receive?</P></BODY></HTML> Fri, 04 May 2018 14:58:29 GMT eduardo_dimperio 2018-05-04T14:58:29Z Forecasting https://community.qlik.com/t5/QlikView/Forecasting/m-p/56238#M774258 <HTML><HEAD></HEAD><BODY><P>Is there a (not too complicated) formula/syntax within a Data Load in Qlik Sense that can be used for forecasting? I have daily data on the number of telephone calls received and would like to project the number of calls for future days/weeks/month. I'm fairly new to Qlik so please be very basic with the explanations <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> . Many thanks in advance...</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Forecasting/m-p/56238#M774258 simonwithey 2020-11-25T16:16:04Z Re: Forecasting https://community.qlik.com/t5/QlikView/Forecasting/m-p/56239#M774259 <HTML><HEAD></HEAD><BODY><P>Not that I know of. But you can get the AVG for a month or day or what ever. Forecasting is rarely easy because there is always a lot of factors that can change the outcome. But for simple non crtitical forecasting just use the AVG values.</P></BODY></HTML> Fri, 04 May 2018 14:41:04 GMT https://community.qlik.com/t5/QlikView/Forecasting/m-p/56239#M774259 bramkn 2018-05-04T14:41:04Z Re: Forecasting https://community.qlik.com/t5/QlikView/Forecasting/m-p/56240#M774260 <HTML><HEAD></HEAD><BODY><P>Hi Simon, sorry, but can you explain better. You just want to show the number of calls that you may receive?</P></BODY></HTML> Fri, 04 May 2018 14:58:29 GMT https://community.qlik.com/t5/QlikView/Forecasting/m-p/56240#M774260 eduardo_dimperio 2018-05-04T14:58:29Z Re: Forecasting https://community.qlik.com/t5/QlikView/Forecasting/m-p/56241#M774261 <HTML><HEAD></HEAD><BODY><P>Hi Eduardo, that is correct. I have calls received per day for a number of weeks/months:</P><P>Sun 123</P><P>Mon 245</P><P>Tue 257</P><P>Wed 268</P><P>Thur 221</P><P>Fri 215</P><P>Sat 112</P><P>etc etc..</P><P>I want to use the actuals to predict how many calls I'll get per day for future weeks/months ...</P></BODY></HTML> Fri, 04 May 2018 15:18:14 GMT https://community.qlik.com/t5/QlikView/Forecasting/m-p/56241#M774261 simonwithey 2018-05-04T15:18:14Z Re: Forecasting https://community.qlik.com/t5/QlikView/Forecasting/m-p/56242#M774262 <HTML><HEAD></HEAD><BODY><P>You could use AVG(Number_of_Calls)</P></BODY></HTML> Fri, 04 May 2018 17:05:18 GMT https://community.qlik.com/t5/QlikView/Forecasting/m-p/56242#M774262 eduardo_dimperio 2018-05-04T17:05:18Z