Open Project Count Prediction for upcoming weeks

Anonymous — Tue, 23 Oct 2018 09:53:43 GMT

Hi All,

I have Combo chart which has two dimension first is week Number and second is flag which has three values in it like RED,GREEN and BLUE. RED and GREEN are the bar . BLUE indicate a line style.

RED are Incoming Project Count , Green are Moved out Project Count and Blue indicate Open Project Count all are per week .

I need to find the Open Project Count Prediction for upcoming weeks, for that we have data of closed Project Count as a new column for upcoming weeks.

Current Week in this Example is CW42 -18.

Till Current Week directly show the OPEN PROJECT COUNT Values , only for Next to Current week need to show

CW43-18 = above (OPEN PROJECT COUNT) - CLOSED PROJECT COUNT . Then it is like Trailing output for

CW44-18 = CW43-18 - CLOSED PROJECT COUNT , CW45-18 = CW44 -18 - CLOSED PROJECT COUNT , Etc....,

Note all the Prediction values need to be comes under BLUE FLAG.

Please help me on this . Thanks in advance

topic Open Project Count Prediction for upcoming weeks in QlikView

Open Project Count Prediction for upcoming weeks