Trouble with Peek()

Anonymous — Wed, 10 Aug 2011 02:17:19 GMT

Hello,

For some reason I'm getting null values from the Peek function, as follows:

Let TwitterID = Peek("Twitter ID",i,UserIDs);

* I've tried the field name as "Twitter ID", "[Twitter ID]", and the latter without quotes (which I gather from the documentation is incorrect, but...)

* i is starting out properly at 0.

* The UserIDs table is correctly loaded prior to this part of the script.

* Every record in the UserIDs table has a non-null value in the [Twitter ID] field, as verified by going to the data model and hitting preview.

Unfortunately, the above-listed assignment statement results in the TwitterID variable being set to NULL each and every time. Any hints?

Thanks in advance,

Kent

Trouble with Peek()

Wed, 10 Aug 2011 03:59:28 GMT

Try with Let TwitterID = Peek('Twitter ID',i,'UserIDs');

Trouble with Peek()

Anonymous — Wed, 10 Aug 2011 05:33:53 GMT

Doh! I knew I was doing something completely stupid. Thanks for the wake-up call.

topic Trouble with Peek() in QlikView

Trouble with Peek()

Trouble with Peek()

Trouble with Peek()