1 Reply Latest reply: Jun 15, 2011 10:51 PM by Jason Vong RSS

    WHERE clause while LOAD qvd.

      Hi all,
      im trying to load a qvd file with a where clause with the codes below:


      LET vDate=Date(Today(),'D/M/YYYY');


      LOAD *

      from C:\Users\KN-4K0YPK1\Desktop\QlikView\GetSCD.qvd(qvd)

      where VALID_FROM = '$(vDate)';


      store Today into C:\Users\KN-4K0YPK1\Desktop\QlikView\Day_$(vDate).qvd;


      But the code doesn't work, help me out please.

      Thanks in advance.