Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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....?

Community Browser