topic Re: Forecasting model on Qlikview in QlikView

Forecasting model on Qlikview

Wed, 02 Aug 2017 12:20:23 GMT

Hi Everyone

I need some assistance with forecasting how many appliances that will need to be purchased for the next 6 months.

I need to get an average count of on for the last 18 months for all 6 months in the future and then split it by dimension(Tier)

Thank you,

Re: Forecasting model on Qlikview

Kushal_Chawda — Wed, 02 Aug 2017 12:37:09 GMT

What is the logic?

Re: Forecasting model on Qlikview

Anil_Babu_Samineni — Wed, 02 Aug 2017 12:41:39 GMT

To get forecast data for 6 months you can do this?

if(Year<> Max(TOTAL Year),sum(Sales),

linest_m(total aggr(if(sum(Sales),sum(Sales)),Year),Year)*Year

+linest_b(total aggr(if(sum(Sales),sum(Sales)),Year),Year))

And to get last 18 months you can do something like below

Sum({<MonthField = {">=$(=AddMonths(Max(MonthField), -18)) <=$(=Max(MonthField))"}>} Sales)

Re: Forecasting model on Qlikview

Wed, 02 Aug 2017 12:49:04 GMT

I will need populate the foretasted count in each month where there is 0 results, the foretasted figure consists of the sales amount by tier times the budgeted percentage*Please Note the budget is not split by tier*

Re: Forecasting model on Qlikview

Kushal_Chawda — Wed, 02 Aug 2017 12:54:00 GMT

I think you mistakenly marked my response as a correct answer, please unmark as correct as it is not actually the answer of your question

Re: Forecasting model on Qlikview

Kushal_Chawda — Wed, 02 Aug 2017 12:56:09 GMT

would you be able to share the sample application?

Re: Forecasting model on Qlikview

Wed, 02 Aug 2017 13:26:19 GMT

Hi there, I still get the same result using both formulas, could it be because we have not broken up the budget by tier?

Re: Forecasting model on Qlikview

Kushal_Chawda — Wed, 02 Aug 2017 13:27:34 GMT

what expression you are using?