2 Replies Latest reply: Sep 5, 2011 4:37 AM by George Beaton RSS

    Conditional Load or Where

    George Beaton

      Hi Folks,

       

      Is it possible to conditionally specify a WHERE statement in QlikView - the following code snippet won't work, but it gives you an idea of what I want to do:

       

      LOAD * FROM  STDQVD\TRANSACTIONS.qvd (qvd)

      if([Allow Sensitive Transactions]='Y'

           ,WHERE NOT EXISTS([Transaction Detail Code],1212,1234,1909)

      );

       

      Any ideas gratefully received.

       

      Many thanks

      George