Discussion Board for collaboration on QlikView Scripting.
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,
Go to Solution.
Try with Let TwitterID = Peek('Twitter ID',i,'UserIDs');
Doh! I knew I was doing something completely stupid. Thanks for the wake-up call.