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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)
)
)
)

 

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