topic AND/OR functions in the data manager in App Development https://community.qlik.com/t5/App-Development/AND-OR-functions-in-the-data-manager/m-p/32058#M2157 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I want to add a calculated field in the data manager. This new column will contain an if formula with an AND and OR condition. However the set expressor in the data manager does not recognize AND/OR functions. Is there a trick to bypass this problem?</P><P></P><P>Regards,</P><P></P><P>Pascal</P></BODY></HTML> Thu, 15 Mar 2018 09:10:19 GMT pascaldijkshoor 2018-03-15T09:10:19Z AND/OR functions in the data manager https://community.qlik.com/t5/App-Development/AND-OR-functions-in-the-data-manager/m-p/32058#M2157 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I want to add a calculated field in the data manager. This new column will contain an if formula with an AND and OR condition. However the set expressor in the data manager does not recognize AND/OR functions. Is there a trick to bypass this problem?</P><P></P><P>Regards,</P><P></P><P>Pascal</P></BODY></HTML> Thu, 15 Mar 2018 09:10:19 GMT https://community.qlik.com/t5/App-Development/AND-OR-functions-in-the-data-manager/m-p/32058#M2157 pascaldijkshoor 2018-03-15T09:10:19Z Re: AND/OR functions in the data manager https://community.qlik.com/t5/App-Development/AND-OR-functions-in-the-data-manager/m-p/32059#M2158 <HTML><HEAD></HEAD><BODY><P>What is your condition that you have to use?</P></BODY></HTML> Thu, 15 Mar 2018 11:23:18 GMT https://community.qlik.com/t5/App-Development/AND-OR-functions-in-the-data-manager/m-p/32059#M2158 sunny_talwar 2018-03-15T11:23:18Z Re: AND/OR functions in the data manager https://community.qlik.com/t5/App-Development/AND-OR-functions-in-the-data-manager/m-p/32060#M2159 <HTML><HEAD></HEAD><BODY><P>This is the formula i want to add:</P><P></P><P>IF (LOAD_Index &gt;=12 OR Right (Com_Code, 1) = 'e' and LOAD_index &gt;=4,1,0)</P></BODY></HTML> Thu, 15 Mar 2018 13:44:16 GMT https://community.qlik.com/t5/App-Development/AND-OR-functions-in-the-data-manager/m-p/32060#M2159 pascaldijkshoor 2018-03-15T13:44:16Z Re: AND/OR functions in the data manager https://community.qlik.com/t5/App-Development/AND-OR-functions-in-the-data-manager/m-p/32061#M2160 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>If(LOAD_Index &gt;= 4,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; If(LOAD_Index &gt;= 12, 1, If(Right(Com_Code, 1) = 'e', 1, 0)))</STRONG><SPAN style="font-size: 10pt;"><STRONG>&nbsp;&nbsp; </STRONG>&nbsp; </SPAN></P></BODY></HTML> Thu, 15 Mar 2018 13:51:58 GMT https://community.qlik.com/t5/App-Development/AND-OR-functions-in-the-data-manager/m-p/32061#M2160 sunny_talwar 2018-03-15T13:51:58Z Re: AND/OR functions in the data manager https://community.qlik.com/t5/App-Development/AND-OR-functions-in-the-data-manager/m-p/32062#M2161 <HTML><HEAD></HEAD><BODY><P>Thanks! This works perfect.</P></BODY></HTML> Fri, 16 Mar 2018 10:03:45 GMT https://community.qlik.com/t5/App-Development/AND-OR-functions-in-the-data-manager/m-p/32062#M2161 pascaldijkshoor 2018-03-16T10:03:45Z