topic Re: Issues with forecast value display in QlikView

Issues with forecast value display

tahreen371 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

If we select 1-Dec -2018 to 15-Dec-2018 it displays the actual value for this and remaining Dates from 16-Dec-2018 upto 31-Dec-2018 it displays the Forecasted value.

But when i select for entire month Example:=1-Dec-2018 to 31-Dec-2018 It should display only Actual value and Forecast value as Zero. But the problem is, it displays the forecast value also for this Selection.

Please help and let me know what is wrong with this equation.

If(GetFieldSelections(Date)=max(Date),

(Sum({<FLAG={'AF'},Date={">=$(vBusinessOnTheBooks_ActualFrom_STLY)<=$(vBusinessOnTheBooks_Actual_To_STLY)"}>}ACTUAL_FORECAST_STAY_ROOMS)),

(Sum({<FLAG={'F'},Date={">=$(vBusinessOnTheBooks_Expected_From_STLY)<=$(vBusinessOnTheBooks_MonthEnd1_STLY)"}>}ACTUAL_FORECAST_STAY_ROOMS)
+
(Sum({<FLAG={'AF'},Date={">=$(vBusinessOnTheBooks_ActualFrom_STLY)<=$(vBusinessOnTheBooks_Actual_To_STLY)"}>}ACTUAL_FORECAST_STAY_ROOMS)))

)

Thanks & Regards in advance

Re: Issues with forecast value display

agni_gold — Mon, 21 Jan 2019 12:25:15 GMT

provide your sample app, will be easy to understand your variables.

Re: Issues with forecast value display

tahreen371 — Mon, 21 Jan 2019 12:25:30 GMT

Please anyone help ASAP... need to submit this requirement real quick

Re: Issues with forecast value display

Anil_Babu_Samineni — Mon, 21 Jan 2019 12:27:31 GMT

What are the variables do?

Re: Issues with forecast value display

tahreen371 — Tue, 22 Jan 2019 04:49:49 GMT

Hello,

These are the four variables i have used for this equation:

1.=If(GetSelectedCount(Date)=0,
Date(Monthstart(Max({$<PERIOD_FLAG={'ACTUAL'}>}Date))),
Date(Monthstart(Max(Date))))

2.=If(GetSelectedCount(Date)=0,
Date(Addyears(Max({$<PERIOD_FLAG={'ACTUAL'}>}Date),-1)),
Date(Addyears(Max(Date),-1)))

3.=If(GetSelectedCount(Date)=0,
Date(Addyears(Max({$<PERIOD_FLAG={'ACTUAL'}>}Date)+1,-1)),
Date(Addyears(Max(Date)+1,-1)))

4.=If(GetSelectedCount(Date)=0,
Date(Monthend(Addyears(Addmonths(Max({$<PERIOD_FLAG={'ACTUAL'}>}Date),0),-1))),
Date(Monthend(Addyears(Addmonths(Max(Date),0),-1))))

Thanks & Regards in advance