Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Where multiple clauses


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





(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