topic Unable to Crack Multiple if Conditions In Qlikview in QlikView https://community.qlik.com/t5/QlikView/Unable-to-Crack-Multiple-if-Conditions-In-Qlikview/m-p/1744540#M720044 <P>Hi Guys,</P><P>Iam Unable to Crack this multiple If Conditions In Qlikview. Could you plz Help this Expression to work out.</P><P><SPAN>If</SPAN><SPAN>(</SPAN><SPAN>[Scenario 1]</SPAN><SPAN>='Yes',(</SPAN><SPAN>Sum</SPAN><SPAN>(</SPAN><SPAN>Volume</SPAN><SPAN>)*</SPAN><SPAN>S1_Replenish_to_Max_Production_split</SPAN><SPAN>),<BR /></SPAN><SPAN>If</SPAN><SPAN>(</SPAN><SPAN>[Scenario 4]</SPAN><SPAN>='Yes',(</SPAN><SPAN>Sum</SPAN><SPAN>(</SPAN><SPAN>Volume</SPAN><SPAN>)*</SPAN><SPAN>S2_S4_Replenish_to_Reorder_Production_split</SPAN><SPAN>),<BR /></SPAN><SPAN>If</SPAN><SPAN>(</SPAN><SPAN>[Scenario 2]</SPAN><SPAN>='Yes',(</SPAN><SPAN>Sum</SPAN><SPAN>(</SPAN><SPAN>Volume</SPAN><SPAN>)*</SPAN><SPAN>S2_S4_Replenish_to_Reorder_Production_split</SPAN><SPAN>),<BR /></SPAN><SPAN>If</SPAN><SPAN>(</SPAN><SPAN>[Scenario 3]</SPAN><SPAN>='Yes',<BR />(<BR /></SPAN><SPAN>Sum</SPAN><SPAN>(</SPAN><SPAN>Volume</SPAN><SPAN>)<BR />-<BR />(</SPAN><SPAN>SUM</SPAN><SPAN>({&lt;</SPAN><SPAN>NumDate</SPAN><SPAN>=,</SPAN><SPAN>DayDateWeekID</SPAN><SPAN>={</SPAN><STRONG><I><SPAN>$(vFutureWEEK1)</SPAN></I></STRONG><SPAN>}&gt;}</SPAN><SPAN>DemandHL</SPAN><SPAN>))<BR />+<BR />(</SPAN><SPAN>SUM</SPAN><SPAN>({&lt;</SPAN><SPAN>NumDate</SPAN><SPAN>=,</SPAN><SPAN>DayDateWeekID</SPAN><SPAN>={</SPAN><STRONG><I><SPAN>$(vFutureWeek2)</SPAN></I></STRONG><SPAN>}&gt;}</SPAN><SPAN>DemandHL</SPAN><SPAN>)*<BR />(((</SPAN><SPAN>Sum</SPAN><SPAN>({&lt;</SPAN><SPAN>DEMAND_FLAG</SPAN><SPAN>={'Daily'}&gt;}</SPAN><SPAN>Min_HL</SPAN><SPAN>)/</SPAN><SPAN>SUM</SPAN><SPAN>({&lt;</SPAN><SPAN>DEMAND_FLAG</SPAN><SPAN>={'Daily'}&gt;}</SPAN><SPAN>ActualDemand</SPAN><SPAN>))/(</SPAN><SPAN>Sum</SPAN><SPAN>({&lt;</SPAN><SPAN>DEMAND_FLAG</SPAN><SPAN>={'Daily'}&gt;}</SPAN><SPAN>Max_HL</SPAN><SPAN>)/</SPAN><SPAN>SUM</SPAN><SPAN>({&lt;</SPAN><SPAN>DEMAND_FLAG</SPAN><SPAN>={'Daily'}&gt;}</SPAN><SPAN>ActualDemand</SPAN><SPAN>)))))<BR />)*</SPAN><SPAN>[S3_Replenish_to_Min_Production_split]</SPAN><SPAN><BR />,0)<BR />)<BR />)<BR />)</SPAN></P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT QVUser1 2020-11-25T16:16:04Z Unable to Crack Multiple if Conditions In Qlikview https://community.qlik.com/t5/QlikView/Unable-to-Crack-Multiple-if-Conditions-In-Qlikview/m-p/1744540#M720044 <P>Hi Guys,</P><P>Iam Unable to Crack this multiple If Conditions In Qlikview. Could you plz Help this Expression to work out.</P><P><SPAN>If</SPAN><SPAN>(</SPAN><SPAN>[Scenario 1]</SPAN><SPAN>='Yes',(</SPAN><SPAN>Sum</SPAN><SPAN>(</SPAN><SPAN>Volume</SPAN><SPAN>)*</SPAN><SPAN>S1_Replenish_to_Max_Production_split</SPAN><SPAN>),<BR /></SPAN><SPAN>If</SPAN><SPAN>(</SPAN><SPAN>[Scenario 4]</SPAN><SPAN>='Yes',(</SPAN><SPAN>Sum</SPAN><SPAN>(</SPAN><SPAN>Volume</SPAN><SPAN>)*</SPAN><SPAN>S2_S4_Replenish_to_Reorder_Production_split</SPAN><SPAN>),<BR /></SPAN><SPAN>If</SPAN><SPAN>(</SPAN><SPAN>[Scenario 2]</SPAN><SPAN>='Yes',(</SPAN><SPAN>Sum</SPAN><SPAN>(</SPAN><SPAN>Volume</SPAN><SPAN>)*</SPAN><SPAN>S2_S4_Replenish_to_Reorder_Production_split</SPAN><SPAN>),<BR /></SPAN><SPAN>If</SPAN><SPAN>(</SPAN><SPAN>[Scenario 3]</SPAN><SPAN>='Yes',<BR />(<BR /></SPAN><SPAN>Sum</SPAN><SPAN>(</SPAN><SPAN>Volume</SPAN><SPAN>)<BR />-<BR />(</SPAN><SPAN>SUM</SPAN><SPAN>({&lt;</SPAN><SPAN>NumDate</SPAN><SPAN>=,</SPAN><SPAN>DayDateWeekID</SPAN><SPAN>={</SPAN><STRONG><I><SPAN>$(vFutureWEEK1)</SPAN></I></STRONG><SPAN>}&gt;}</SPAN><SPAN>DemandHL</SPAN><SPAN>))<BR />+<BR />(</SPAN><SPAN>SUM</SPAN><SPAN>({&lt;</SPAN><SPAN>NumDate</SPAN><SPAN>=,</SPAN><SPAN>DayDateWeekID</SPAN><SPAN>={</SPAN><STRONG><I><SPAN>$(vFutureWeek2)</SPAN></I></STRONG><SPAN>}&gt;}</SPAN><SPAN>DemandHL</SPAN><SPAN>)*<BR />(((</SPAN><SPAN>Sum</SPAN><SPAN>({&lt;</SPAN><SPAN>DEMAND_FLAG</SPAN><SPAN>={'Daily'}&gt;}</SPAN><SPAN>Min_HL</SPAN><SPAN>)/</SPAN><SPAN>SUM</SPAN><SPAN>({&lt;</SPAN><SPAN>DEMAND_FLAG</SPAN><SPAN>={'Daily'}&gt;}</SPAN><SPAN>ActualDemand</SPAN><SPAN>))/(</SPAN><SPAN>Sum</SPAN><SPAN>({&lt;</SPAN><SPAN>DEMAND_FLAG</SPAN><SPAN>={'Daily'}&gt;}</SPAN><SPAN>Max_HL</SPAN><SPAN>)/</SPAN><SPAN>SUM</SPAN><SPAN>({&lt;</SPAN><SPAN>DEMAND_FLAG</SPAN><SPAN>={'Daily'}&gt;}</SPAN><SPAN>ActualDemand</SPAN><SPAN>)))))<BR />)*</SPAN><SPAN>[S3_Replenish_to_Min_Production_split]</SPAN><SPAN><BR />,0)<BR />)<BR />)<BR />)</SPAN></P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Unable-to-Crack-Multiple-if-Conditions-In-Qlikview/m-p/1744540#M720044 QVUser1 2020-11-25T16:16:04Z Re: Unable to Crack Multiple if Conditions In Qlikview https://community.qlik.com/t5/QlikView/Unable-to-Crack-Multiple-if-Conditions-In-Qlikview/m-p/1744847#M720045 <P>you are using this in a chart rt?&nbsp;&nbsp;<BR />the expression looks fine.&nbsp; to figure out whats happening, you may need to attach the QVW</P> Thu, 17 Sep 2020 16:14:06 GMT https://community.qlik.com/t5/QlikView/Unable-to-Crack-Multiple-if-Conditions-In-Qlikview/m-p/1744847#M720045 edwin 2020-09-17T16:14:06Z