Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Forecasting and a chart in qlikview

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..

T.PNG

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

4 Replies
dapostolopoylos
Creator III
Creator III

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

Father/Husband/BI Developer
arvind_patil
Partner - Specialist III
Partner - Specialist III

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
Creator III
Creator III
Author

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

bharatkishore
Creator III
Creator III
Author

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