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

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
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.

Labels (1)
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').