https://community.qlik.com/t5/QlikView/logic-problem-qlikview/m-p/1552125#M743573 <P>Thank u for the reply.</P><P>&nbsp;</P><P>However, the logic should include one more condition stating only Automatic postings , i need the logic below.&nbsp;</P> Tue, 05 Mar 2019 06:18:43 GMT andrea0901 2019-03-05T06:18:43Z https://community.qlik.com/t5/QlikView/logic-problem-qlikview/m-p/1552100#M743571 <P>Hi All,</P><P>&nbsp;</P><P>I have a requirement like below:</P><TABLE><TBODY><TR><TD><STRONG>ER1</STRONG></TD><TD><STRONG>ER2</STRONG></TD><TD><STRONG>AUTO</STRONG></TD><TD><STRONG>LIVE</STRONG></TD></TR><TR><TD>BAP_OCI</TD><TD>BAP_OCI</TD><TD>Automatic</TD><TD>ICC</TD></TR><TR><TD>AC</TD><TD>AC</TD><TD>Automatic</TD><TD>SAP</TD></TR><TR><TD>Akumar</TD><TD>Akumar</TD><TD>Automatic</TD><TD>ICC</TD></TR><TR><TD>Ashek</TD><TD>Ashek</TD><TD>Automatic</TD><TD>SAP</TD></TR><TR><TD>aniyas</TD><TD>aniyas</TD><TD>Automatic</TD><TD>ICC</TD></TR><TR><TD>BAP_OCI</TD><TD>BAP_OCI</TD><TD>Not Automatic</TD><TD>SAP</TD></TR><TR><TD>AC</TD><TD>AC</TD><TD>Not Automatic</TD><TD>ICC</TD></TR><TR><TD>Akumar</TD><TD>Akumar</TD><TD>Not Automatic</TD><TD>SAP</TD></TR><TR><TD>Ashek</TD><TD>Ashek</TD><TD>Not Automatic</TD><TD>ICC</TD></TR><TR><TD>aniyas</TD><TD>aniyas</TD><TD>Not Automatic</TD><TD>SAP</TD></TR></TBODY></TABLE><P>&nbsp;</P><P class="x_MsoListParagraph">For all "<STRONG>Automatic</STRONG>" postings&nbsp; ---&gt;&gt;&gt; '<STRONG>LIVE</STRONG>'&nbsp;field will be changed based on below logic</P><P class="x_MsoListParagraph"><SPAN>a.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN>if <STRONG>ER1</STRONG> &amp; <STRONG>ER2</STRONG> = BAP_OCI then <STRONG>LIVE</STRONG> field should show = ICC</P><P class="x_MsoListParagraph"><SPAN>b.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</SPAN>if <STRONG>ER1</STRONG> &amp; <STRONG>ER2</STRONG> not equal to BAP_OCI then <STRONG>LIVE</STRONG> field should show = SAP</P><P class="x_MsoListParagraph">&nbsp;</P><P class="x_MsoListParagraph">Please help me how to do it in qlikview.</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/logic-problem-qlikview/m-p/1552100#M743571 andrea0901 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/logic-problem-qlikview/m-p/1552109#M743572 <P>Use this :&nbsp;</P><P>=only(if(ER1='BAP_OCI' and ER2='BAP_OCI','ICC','SAP'))</P> Tue, 05 Mar 2019 05:48:02 GMT https://community.qlik.com/t5/QlikView/logic-problem-qlikview/m-p/1552109#M743572 Shubham_Deshmukh 2019-03-05T05:48:02Z https://community.qlik.com/t5/QlikView/logic-problem-qlikview/m-p/1552125#M743573 <P>Thank u for the reply.</P><P>&nbsp;</P><P>However, the logic should include one more condition stating only Automatic postings , i need the logic below.&nbsp;</P> Tue, 05 Mar 2019 06:18:43 GMT https://community.qlik.com/t5/QlikView/logic-problem-qlikview/m-p/1552125#M743573 andrea0901 2019-03-05T06:18:43Z https://community.qlik.com/t5/QlikView/logic-problem-qlikview/m-p/1552129#M743574 =only(if(ER1='BAP_OCI' and ER2='BAP_OCI' and AUTO='Automatic' ,'ICC','SAP'))<BR />Mark the solution as an answer if it solves your problem. Tue, 05 Mar 2019 06:32:27 GMT https://community.qlik.com/t5/QlikView/logic-problem-qlikview/m-p/1552129#M743574 Shubham_Deshmukh 2019-03-05T06:32:27Z