Discussion Board for collaboration on QlikView Scripting.
Facing issues,while using where condition in QVD load,
LET vDate = MakeDate(Year(Today()),Month(Today()),1);
Load * z,y,z,EndDate
from FROM [..\..\Shared QVD\test.qvd] (qvd)
where EndDate >= $(vDate)
Why don't you try this:
FROM [..\..\Shared QVD\test.qvd] (qvd)
where EndDate >= Date(Today());
Or this if you want from the starting of the month:
Where EndDate >= Date(MonthStart(Today()));
load without where condition and then load from resident table using where
noconcatenate load *
drop table TEST
loading from a qvd without where clause will be done by an optimized load which is much faster
(upto 10times faster)
Unfortunately its not working....Is there any issue with the date format of End Date?
Yes how does your EndDate Look? Can you share a screenshot of your EndDate data?
where Date(Date#(EndDate, 'MM/DD/YYYY')) >= Date(Today());
Often comparing dates as formatted dates and not as numerical dates can be quite hard to get working correctly.
Try to convert the dates to numerical dates:
LET vDate = MonthStart( Today() );
LET vNumDate = Num( vDate );
WHERE Num(EndDate) >= $(vNumDate);
where EndDate >= '$(vDate)'