Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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').