Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Jagsfan82
Partner - Contributor III
Partner - Contributor III

Peek not working

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');

2 Replies
bharathadde
Creator II
Creator II

Try this

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

bharathadde
Creator II
Creator II

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');