Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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');