topic Peek returns null value in QlikView

Peek returns null value

Wed, 29 Jul 2009 17:07:43 GMT

Hi,

I'm trying to use peek , but returns null. Code is like this:

DATES1:

LOAD

DATE

.....

LET varMDate = Num(Peek(DATE, 0, DATES1))

.....

Any clue?

-Arun

Wed, 29 Jul 2009 17:14:09 GMT

I guess the code should be

LET varMDate = Num(Peek('DATE', 0, 'DATES1'))

Wed, 29 Jul 2009 17:20:24 GMT

Amit, no luck.

-Arun

Wed, 29 Jul 2009 18:13:15 GMT

Arun, are you sure that the value is not null in source data? Try putting some other number instead of 0 in that code and see if it still gives null.

Thanks

Amit

Wed, 29 Jul 2009 18:32:49 GMT

Amit,

Yes, I was trying that. and for some other random number is is returning value. Now I'm out of the dark.

Thanks Bud.

-Arun