topic WHERE clause problem in script in QlikView https://community.qlik.com/t5/QlikView/WHERE-clause-problem-in-script/m-p/154207#M30912 <HTML><HEAD></HEAD><BODY><P>please put this condition</P><P></P><P>Where upper(left(ITEMCODE,1))='F'</P><P></P><P>Regards</P><P>Ashish Srivastava</P></BODY></HTML> Tue, 10 Aug 2010 10:17:26 GMT 2010-08-10T10:17:26Z WHERE clause problem in script https://community.qlik.com/t5/QlikView/WHERE-clause-problem-in-script/m-p/154206#M30911 <HTML><HEAD></HEAD><BODY><P>I have a field called ItemCode. I only want to load all items starting with 'F'.</P><P>I have problems writing the script to only load these fields. I currently have this script:</P><H4>LOAD</H4><H4>upper(ItemCode) as ItemCode,</H4><H4>upper(WhsCode) as WhsCode,</H4><H4>OnHand</H4><H4>FROM H:\QvData\DOS\OITW.qvd(qvd)</H4><H4>WHERE ItemCode=('F*');</H4></BODY></HTML> Tue, 10 Aug 2010 10:08:43 GMT https://community.qlik.com/t5/QlikView/WHERE-clause-problem-in-script/m-p/154206#M30911 2010-08-10T10:08:43Z WHERE clause problem in script https://community.qlik.com/t5/QlikView/WHERE-clause-problem-in-script/m-p/154207#M30912 <HTML><HEAD></HEAD><BODY><P>please put this condition</P><P></P><P>Where upper(left(ITEMCODE,1))='F'</P><P></P><P>Regards</P><P>Ashish Srivastava</P></BODY></HTML> Tue, 10 Aug 2010 10:17:26 GMT https://community.qlik.com/t5/QlikView/WHERE-clause-problem-in-script/m-p/154207#M30912 2010-08-10T10:17:26Z WHERE clause problem in script https://community.qlik.com/t5/QlikView/WHERE-clause-problem-in-script/m-p/154208#M30913 <HTML><HEAD></HEAD><BODY><P>Thanks for the help. This worked perfectly.</P></BODY></HTML> Tue, 10 Aug 2010 10:35:29 GMT https://community.qlik.com/t5/QlikView/WHERE-clause-problem-in-script/m-p/154208#M30913 2010-08-10T10:35:29Z