Forecasting and a chart in qlikview

[bharatkishore]

Hi All,

Can we built the below image chart in qlikview. IF so can you please suggest me how to do.

stalwar1‌ Can you suggest anything Sunny Bhai..

The attached image is from excel and it is about forecasting.

Can you please suggest me where i can get some info to built the attached chart in qlikview and also how to do forecasting.

Thanks,

Bharat

[dapostolopoylos]

Check out those links:

How to do Forecasting In Qlikview( with Example)

Forecasting in Qlikview

How to implement predictive analysis with QlikView?

To be honest i myself didn't manage to come up with a solution that i could present my users but you may have better luck

[arvind_patil]

Hi Bharat,

Create Forcast calender and change your expression like below:

=if(IsNull(Sum({<Date={">=$(=YearStart(Max(Date),0,4))<=$(=monthend(addmonths(Max(Date),-1)))"},Month=>}value)/vNumber) or

(Sum({<Date={">=$(=YearStart(Max(Date),0,4))<=$(=addmonths(Max(Date),-1))"},Month=>}value)/vNumber) = 0,

  linest_m(total aggr(if(Sum({<Date={">=$(=monthstart(addmonths(Max(Date),-3)))<=$(=monthend(addmonths(Max(Date),-1)))"},Month=>}value)/vNumber,

Sum({<Date={">=$(=monthstart(addmonths(Max(Date),-3)))<=$(=monthend(addmonths(Max(Date),-1)))"},Month=>}value)/vNumber),ForecastMonthYear),ForecastMonthYear)  * ForecastMonthYear

+

linest_b(total aggr(if(Sum({<Date={">=$(=monthstart(addmonths(Max(Date),-3)))<=$(=monthend(addmonths(Max(Date),-1)))"},Month=>}value)/vNumber,

Sum({<Date={">=$(=monthstart(addmonths(Max(Date),-3)))<=$(=monthend(addmonths(Max(Date),-1)))"},Month=>}value)/vNumber),ForecastMonthYear),ForecastMonthYear),

Sum({<Date={">=$(=YearStart(Max(Date),0,4))<=$(=monthend(addmonths(Max(Date),-1)))"},Month=>}value)/vNumber

)

Thanks,

Arvind Patil

[bharatkishore]

Thanks Arvind.. But is there any way we can show the above graph in qlikivew.

[bharatkishore]

Thanks Dimitrios. Will look at all the links you have provided, Thank you..