topic How to use Resident Where AND OR as below sample in QlikView https://community.qlik.com/t5/QlikView/How-to-use-Resident-Where-AND-OR-as-below-sample/m-p/218639#M71726 <HTML><HEAD></HEAD><BODY><P>Is it possible that the problem is really in the P_AUX table, where you want to join this table (maybe there is a problem with field names) ?</P><P>BR, Miha</P></BODY></HTML> Fri, 09 Jul 2010 09:53:44 GMT 2010-07-09T09:53:44Z How to use Resident Where AND OR as below sample https://community.qlik.com/t5/QlikView/How-to-use-Resident-Where-AND-OR-as-below-sample/m-p/218637#M71724 <HTML><HEAD></HEAD><BODY><P>I keep the code as below, but the "where" condition doesn't working, who can help?</P><P>Thanks</P><P>Join(P_AUX)<BR /> Load<BR /> %ITM,<BR /> 'Selecting' as SELT,<BR /> [UMCONV] as QTYS<BR /> resident ITEM WHERE left([Segm 3],2)&lt;&gt;'WF' OR [Segm 3]&lt;&gt;'STU' OR [Segm 3]&lt;&gt;'REJ' OR [Segm 3]&lt;&gt;'GOA' OR [Segm 3]&lt;&gt;'SVA';</P></BODY></HTML> Fri, 09 Jul 2010 09:01:11 GMT https://community.qlik.com/t5/QlikView/How-to-use-Resident-Where-AND-OR-as-below-sample/m-p/218637#M71724 2010-07-09T09:01:11Z How to use Resident Where AND OR as below sample https://community.qlik.com/t5/QlikView/How-to-use-Resident-Where-AND-OR-as-below-sample/m-p/218638#M71725 <HTML><HEAD></HEAD><BODY><P>do you have field [Segm 3] in the ITEM table?</P><P></P></BODY></HTML> Fri, 09 Jul 2010 09:45:04 GMT https://community.qlik.com/t5/QlikView/How-to-use-Resident-Where-AND-OR-as-below-sample/m-p/218638#M71725 sparur 2010-07-09T09:45:04Z How to use Resident Where AND OR as below sample https://community.qlik.com/t5/QlikView/How-to-use-Resident-Where-AND-OR-as-below-sample/m-p/218639#M71726 <HTML><HEAD></HEAD><BODY><P>Is it possible that the problem is really in the P_AUX table, where you want to join this table (maybe there is a problem with field names) ?</P><P>BR, Miha</P></BODY></HTML> Fri, 09 Jul 2010 09:53:44 GMT https://community.qlik.com/t5/QlikView/How-to-use-Resident-Where-AND-OR-as-below-sample/m-p/218639#M71726 2010-07-09T09:53:44Z How to use Resident Where AND OR as below sample https://community.qlik.com/t5/QlikView/How-to-use-Resident-Where-AND-OR-as-below-sample/m-p/218640#M71727 <HTML><HEAD></HEAD><BODY><P>All the records will pass the test because you use 'not equal' (&lt;&gt;) combined with OR.</P><P>Replacing the OR with AND will solve your problem.</P><P>Huub</P><P></P></BODY></HTML> Fri, 09 Jul 2010 11:03:34 GMT https://community.qlik.com/t5/QlikView/How-to-use-Resident-Where-AND-OR-as-below-sample/m-p/218640#M71727 2010-07-09T11:03:34Z How to use Resident Where AND OR as below sample https://community.qlik.com/t5/QlikView/How-to-use-Resident-Where-AND-OR-as-below-sample/m-p/218641#M71728 <HTML><HEAD></HEAD><BODY><P>you are true man, thanks.</P></BODY></HTML> Mon, 12 Jul 2010 01:56:43 GMT https://community.qlik.com/t5/QlikView/How-to-use-Resident-Where-AND-OR-as-below-sample/m-p/218641#M71728 2010-07-12T01:56:43Z