Set variable by using a resident table

yipchunyu — Wed, 25 Nov 2020 16:16:04 GMT

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.

MaxDate:

Load

Max(date)

Resident A;

Result:

Load

Resident

Temp

Where date = vThisWeek ;

Can sample for aforesaid example?

Re: Set variable by using a resident table

marcus_malinow — Tue, 02 Jul 2019 08:53:49 GMT

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.

E.g.

MaxDate:

Load max(Date) as MaxDate

RESIDENT A;

LET vMaxDate = peek('MaxDate', -1);

topic Set variable by using a resident table in QlikView

Set variable by using a resident table

Re: Set variable by using a resident table