Peek not working

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

Hello all. I cannot figure out why my peek isn't working. The "ScopingDates" table loads with 1 row and a date value in both columns. The values and variables are coming up as Null() when I go through the debugger. I am able to pull back NoOfRows to be 1 and set that to a variable. I guess for some reason it's just coming up with a null for the value of those fields.

=========

ScopingDates:
Directory;
First 1
LOAD IA_Scope_Period_Beg_Dt,
IA_Scope_Period_End_Dt
FROM
QVD\AirDetails.QVD
(qvd);

ELSEIF NOT IsNull(FileTime('QVD\ProfitDetails.QVD')) THEN

Directory;
Concatenate
First 1
LOAD IA_Scope_Period_Beg_Dt,
IA_Scope_Period_End_Dt
FROM
QVD\ProfitDetails.QVD
(qvd);

END IF;

let ScopeBegin = peek(IA_Scope_Period_Beg_Dt,-1,'ScopingDates');
let ScopeEnd = peek(IA_Scope_Period_End_Dt,-1,'ScopingDates');

Re: Peek not working

bharathadde — Mon, 01 Jul 2019 20:55:41 GMT

Try this

let ScopeBegin = peek('IA_Scope_Period_Beg_Dt',-1,ScopingDates);
let ScopeEnd = peek('IA_Scope_Period_End_Dt',-1,ScopingDates);

Re: Peek not working

bharathadde — Mon, 01 Jul 2019 21:02:14 GMT

Sorry please try this one

let ScopeBegin = peek('IA_Scope_Period_Beg_Dt',-1,'ScopingDates');
let ScopeEnd = peek('IA_Scope_Period_End_Dt',-1,'ScopingDates');

topic Re: Peek not working in QlikView

Peek not working

Re: Peek not working

Re: Peek not working