Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Where multiple clauses

Hi

I'm optimizing my script and the following doesn't anymore:

LOAD

...

FROM

$(vstoresource)XXXXXXXXXXXX.xlsx

(ooxml, embedded labels, table is XXX)

where wildmatch([Derde nummer opdracht], '130044', '80004', '190089') and not Exists(Opdracht) ;

What I did before was creating a QVD with a where wildmatch([Derde nummer opdracht], '130044', '80004', '190089') clause,

then load that qvd again with a where not Exists(Opdracht) ; clause.

Seemed to me that this could be done without creating a QVD first but Qlikview keeps loading 0 records....

What should the correct syntax be for where .... and not exist....?