Discussion board where members can get started with QlikView.
In the loading scripts, I have a resident table and inside the table I can extract a max(date) field. And then I would like to use this date field to further filter out other tables in the later part of the scripts e.g.
<Let / Set scripts >
Where date = vThisWeek ;
Can sample for aforesaid example?
Go to Solution.
If I understand you correctly, it sounds like you might want to use a peek statement to extract your max date field into a variable.
Load max(Date) as MaxDate
LET vMaxDate = peek('MaxDate', -1);
View solution in original post