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

    WHERE clause while LOAD qvd.

    Jason Vong

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

       

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

      Today:

      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.