Hi, I am trying to create a table like below, where Actuals and Forecasts are shown in the same table. Users will be able to compare forecasts made in different months with the Actual numbers and c...
Esta nota está publicada en el blog Qlikview en Español Viene de una pregunta del foro publicada aqui Si se tiene una tabla de ventas y se quiere predecir ventas futuras, teniendo algo como: ...
I've found this formula: suppose: you have as an expression: Sum(Revenue) to forecast it: if(SUM(Revenue),SUM(Revenue), linest_m(total aggr(if(SUM(Revenue),SUM(Revenue)),Display_Date),D...
...lerting for Windows Sept 2020 (although any Qlik Alerting version will work) In this example we show a seasonally adjusted forecasting algorithm (grey), Holt Winters, which is taking all of the d...
...reate this in load Statement to create a canonical calender to join several calender dates like Orders to create a forecast. This is just a part of my hole problem but find a solution for this p...
...ales forecast For example: Sale of item A from 01/01/2015 to today is 25420 Today is day 202 of the year Sales for each day are 25420/202 = 125,8415842 31/07/2015 will be the 212 day of the year I...
Hi every one , I have a excel like below, i want a bar chart that show sale amount for exist year and show forecast sales for 2016(next year) , which function i can do ? please help me ? B...
Dear all I have problem in writing script to forecast the sales volume, please help urgently. The correct answer is computed and shown in the worksheet. Thank you Tracy
.png "Former Employee"){kind=icon}