topic Forecasting and a chart in qlikview in QlikView

Forecasting and a chart in qlikview

bharatkishore — Thu, 02 Aug 2018 07:44:20 GMT

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

Re: Forecasting and a chart in qlikview

dapostolopoylos — Thu, 02 Aug 2018 07:49:55 GMT

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

Re: Forecasting and a chart in qlikview

arvind_patil — Thu, 02 Aug 2018 07:59:35 GMT

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

Re: Forecasting and a chart in qlikview

bharatkishore — Thu, 02 Aug 2018 08:01:43 GMT

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

Re: Forecasting and a chart in qlikview

bharatkishore — Thu, 02 Aug 2018 08:02:20 GMT

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