Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
QVUser1
Partner - Contributor III
Partner - Contributor III

Unable to Crack Multiple if Conditions In Qlikview

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

 

Labels (1)
1 Reply
edwin
Master II
Master II

you are using this in a chart rt?  
the expression looks fine.  to figure out whats happening, you may need to attach the QVW