topic Re: Problem on peek() function in QlikView

Problem on peek() function

Tue, 29 Jan 2013 14:54:16 GMT

Hi there Qlikview addicts,

I have encountered an unexpected behaviour on my peek function. Allthough the fields testing 1 and testing 2 are calulated correctly my field of testing 3 gives me an error on OATimestamp('Field not found').Can anyone help??? I have attached my code below.Thanks in advance.

OperatorActivity:

LOAD

sessionID,

user,

activity,

activityID,

timestamp as OATimestamp,

peek(sessionID),//testing 1

peek(OATimestamp) as PastTimestamp,//testing 2

if(peek(sessionID)=sessionID,dayStart(timestamp(peek(OATimestamp)))-dayStart(timestamp(OATimestamp)))as TimestampDiffTest;//testing 3

SQL SELECT

oa.sessionID,

oa.user,

oa.activity,

oa.activityID,

oa.timestamp

from syspro_to_ops.operator_activity as oa;

Re: Problem on peek() function

Gysbert_Wassenaar — Tue, 29 Jan 2013 15:06:05 GMT

You're creating OATimestamp as a new field. That's why peek can't find it. You'll have to use the original name:

peek(timestamp) as PastTimestamp

Re: Problem on peek() function

Tue, 29 Jan 2013 15:13:07 GMT

if i use

	peek(timestamp) as PastTimestamp2,//testing
	if(peek(sessionID)=sessionID,dayStart(timestamp(peek(timestamp)))-dayStart(timestamp(timestamp)))as TimestampDiffTest;//testing

i get no result either for PastTimestamp2 nor for TimestampDiffTest

Re: Problem on peek() function

rwunderlich — Tue, 29 Jan 2013 15:34:34 GMT

You need single quotes around your fieldname in the peek().

peek('OATimestamp')

-Rob

http://robwunderlich.com

Re: Problem on peek() function

Tue, 29 Jan 2013 15:40:47 GMT

Tried both of the proposed solution but it do not seem to work.

I am wondering how can

peek(OATimestamp) as PastTimestamp,//testing 2

give a result and

if(peek(sessionID)=sessionID,dayStart(timestamp(peek(OATimestamp)))-dayStart(timestamp(OATimestamp)))as TimestampDiffTest;//testing 3

Give null????

Re: Problem on peek() function

Tue, 29 Jan 2013 15:42:18 GMT

Tried that as well ....no luck...

Re: Problem on peek() function

rwunderlich — Tue, 29 Jan 2013 23:56:44 GMT

I would think that

dayStart(timestamp(OATimestamp))

would be a "Field not found" in the current row. OATimestamp does not yet exist.

-Rob