Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Iam Unable to Crack this multiple If Conditions In Qlikview. Could you plz Help this Expression to work out.
If([Scenario 1]='Yes',(Sum(Volume)*S1_Replenish_to_Max_Production_split),If([Scenario 4]='Yes',(Sum(Volume)*S2_S4_Replenish_to_Reorder_Production_split),If([Scenario 2]='Yes',(Sum(Volume)*S2_S4_Replenish_to_Reorder_Production_split),If([Scenario 3]='Yes',(Sum(Volume)-(SUM({<NumDate=,DayDateWeekID={$(vFutureWEEK1)}>}DemandHL))+(SUM({<NumDate=,DayDateWeekID={$(vFutureWeek2)}>}DemandHL)*(((Sum({<DEMAND_FLAG={'Daily'}>}Min_HL)/SUM({<DEMAND_FLAG={'Daily'}>}ActualDemand))/(Sum({<DEMAND_FLAG={'Daily'}>}Max_HL)/SUM({<DEMAND_FLAG={'Daily'}>}ActualDemand))))))*[S3_Replenish_to_Min_Production_split],0))))
you are using this in a chart rt? the expression looks fine. to figure out whats happening, you may need to attach the QVW