0 Replies Latest reply: Sep 30, 2015 9:45 AM by Ruud Cruchten RSS

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