Forecasting model on Qlikview

[#1]

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,

[Kushal_Chawda]

What is the logic?

[Anil_Babu_Samineni]

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)

[#4]

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*

[Kushal_Chawda]

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

[Kushal_Chawda]

would you be able to share the sample application?

[#7]

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

[Kushal_Chawda]

what expression you are using?