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

Announcements
Join us at Qlik Connect 2026 in Orlando, April 13–15: Register 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)
)
)
)

 

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