topic Where multiple clauses in QlikView https://community.qlik.com/t5/QlikView/Where-multiple-clauses/m-p/970119#M647405 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I'm optimizing my script and the following doesn't anymore:</P><P>LOAD</P><P>...</P><P>FROM</P><P>$(vstoresource)XXXXXXXXXXXX.xlsx</P><P>(ooxml, embedded labels, table is XXX)</P><P>where wildmatch([Derde nummer opdracht], '130044', '80004', '190089') and not Exists(Opdracht) ;</P><P></P><P>What I did before was creating a QVD with a where wildmatch([Derde nummer opdracht], '130044', '80004', '190089') clause,</P><P>then load that qvd again with a where not Exists(Opdracht) ; clause.</P><P></P><P>Seemed to me that this could be done without creating a QVD first but Qlikview keeps loading 0 records....</P><P></P><P>What should the correct syntax be for where .... and not exist....?</P></BODY></HTML> Wed, 30 Sep 2015 13:45:00 GMT 2015-09-30T13:45:00Z Where multiple clauses https://community.qlik.com/t5/QlikView/Where-multiple-clauses/m-p/970119#M647405 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I'm optimizing my script and the following doesn't anymore:</P><P>LOAD</P><P>...</P><P>FROM</P><P>$(vstoresource)XXXXXXXXXXXX.xlsx</P><P>(ooxml, embedded labels, table is XXX)</P><P>where wildmatch([Derde nummer opdracht], '130044', '80004', '190089') and not Exists(Opdracht) ;</P><P></P><P>What I did before was creating a QVD with a where wildmatch([Derde nummer opdracht], '130044', '80004', '190089') clause,</P><P>then load that qvd again with a where not Exists(Opdracht) ; clause.</P><P></P><P>Seemed to me that this could be done without creating a QVD first but Qlikview keeps loading 0 records....</P><P></P><P>What should the correct syntax be for where .... and not exist....?</P></BODY></HTML> Wed, 30 Sep 2015 13:45:00 GMT https://community.qlik.com/t5/QlikView/Where-multiple-clauses/m-p/970119#M647405 2015-09-30T13:45:00Z