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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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