Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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');

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.

1 Reply
Not applicable
Author

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').