WHERE clause while LOAD qvd.

Thu, 16 Jun 2011 02:32:31 GMT

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.

Thu, 16 Jun 2011 02:51:03 GMT

It works when I:

LET vDate=Floor(MakeDate(2011,6,16));

So it is sure that it has a problem with Date(Today(),'D/M/YYYY').

topic WHERE clause while LOAD qvd. in QlikView