topic Re: Save Last and before last dates in Date field as Script variables and using them with in the script in where condition.. in QlikView

Save Last and before last dates in Date field as Script variables and using them with in the script in where condition..

Wed, 08 May 2013 18:17:43 GMT

Can I save Last and before last dates in a date field as script variables and use them in where condition while joinning?

Gysbert_Wassenaar — Wed, 08 May 2013 18:22:28 GMT

Sure, assuming your date field is named Date:

LET vLastDate = peek('Date');

LET vBeforeLastDate = peek('Date',-2);

If you want the max and second highest try:

Temp:

load max(Date) as Max1, max(Date,2) as Max2

Resident ...table_with_dates...;

LET vMax1 = peek('Max1');

LET vMax2 = peek('Max2');

drop Table Temp;

You can use the variables like this:

load * from ...sometable...

where OrderDate <= $(vLastDate) ;

Wed, 08 May 2013 18:40:55 GMT

Thanks..