Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

WHERE clause while LOAD qvd.

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

Community Browser