topic Re: If Condition in QlikView https://community.qlik.com/t5/QlikView/If-Condition/m-p/1245889#M395107 <HTML><HEAD></HEAD><BODY><P>Hi Dinesh,</P><P>Use below If condition: (Assuming denominator <STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum(SHIPPED_QUANTITY)</STRONG> &lt;&gt; 0 in your case)</P><P></P><P>If(</P><P>&nbsp; sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST) =0 and </P><P>&nbsp; <SPAN style="font-size: 10pt;">sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)=0</SPAN></P><P>,[Old LO]</P><P>, (sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST) / sum(SHIPPED_QUANTITY) </P><P>&nbsp; +</P><P>&nbsp; sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)/ sum(SHIPPED_QUANTITY))</P><P>)</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 21 Mar 2017 05:45:57 GMT Anonymous 2017-03-21T05:45:57Z If Condition https://community.qlik.com/t5/QlikView/If-Condition/m-p/1245886#M395104 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">how to write this as proper expression </SPAN></P><P>show me </P><P>sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST) / sum(SHIPPED_QUANTITY) + </P><P>sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)/ sum(SHIPPED_QUANTITY)</P><P></P><P>If above expression gives zero </P><P></P><P>show me </P><P><SPAN style="font-size: 10pt;">[Old LO] in same column </SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Thanks</SPAN></P><P><SPAN style="font-size: 10pt;">D<BR /></SPAN></P></BODY></HTML> Mon, 20 Mar 2017 19:54:09 GMT https://community.qlik.com/t5/QlikView/If-Condition/m-p/1245886#M395104 dseelam 2017-03-20T19:54:09Z Re: If Condition https://community.qlik.com/t5/QlikView/If-Condition/m-p/1245887#M395105 <HTML><HEAD></HEAD><BODY><P><STRONG>If(</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>(sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST) / sum(SHIPPED_QUANTITY) +</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)/ sum(SHIPPED_QUANTITY))=0,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">[Old LO],</SPAN></STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>(sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST) / sum(SHIPPED_QUANTITY) +</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)/ sum(SHIPPED_QUANTITY))</STRONG></P><P><STRONG>)</STRONG></P></BODY></HTML> Mon, 20 Mar 2017 20:25:00 GMT https://community.qlik.com/t5/QlikView/If-Condition/m-p/1245887#M395105 aarkay29 2017-03-20T20:25:00Z Re: If Condition https://community.qlik.com/t5/QlikView/If-Condition/m-p/1245888#M395106 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">try this:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>If(</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>((sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST)&nbsp; + sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)) / </STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>sum(SHIPPED_QUANTITY))=0, <SPAN style="font-style: inherit; font-size: 13.3333px;">[Old LO],</SPAN></STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>((sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST)&nbsp; + sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)) / </STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>sum(SHIPPED_QUANTITY))</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>)</STRONG></P></BODY></HTML> Tue, 21 Mar 2017 05:31:15 GMT https://community.qlik.com/t5/QlikView/If-Condition/m-p/1245888#M395106 hemanthaanichet 2017-03-21T05:31:15Z Re: If Condition https://community.qlik.com/t5/QlikView/If-Condition/m-p/1245889#M395107 <HTML><HEAD></HEAD><BODY><P>Hi Dinesh,</P><P>Use below If condition: (Assuming denominator <STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">sum(SHIPPED_QUANTITY)</STRONG> &lt;&gt; 0 in your case)</P><P></P><P>If(</P><P>&nbsp; sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST) =0 and </P><P>&nbsp; <SPAN style="font-size: 10pt;">sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)=0</SPAN></P><P>,[Old LO]</P><P>, (sum(SHIPPED_QUANTITY*ACTUAL_RESOURCE_COST) / sum(SHIPPED_QUANTITY) </P><P>&nbsp; +</P><P>&nbsp; sum(SHIPPED_QUANTITY*ACTUAL_OVERHEAD_COST)/ sum(SHIPPED_QUANTITY))</P><P>)</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 21 Mar 2017 05:45:57 GMT https://community.qlik.com/t5/QlikView/If-Condition/m-p/1245889#M395107 Anonymous 2017-03-21T05:45:57Z