Issue with PEEk

datanibbler — Tue, 05 Apr 2016 08:42:41 GMT

Hi guys,

I have an issue with a PEEK() function: I know how it works - I have to enclose the fieldname in quotes, then comes a counter and then the tablename

=> So when I have a table named >>Temp2<< and I want the field >>ID<< from the first record, I go like

>> PEEK('ID', 0, Temp2) <<

I can also do that in a loop, I only have to use $(i) instead of that 0 (if i is my counter)

<=> That is the issue: That does not work and I cannot spot any typo or similar - in fact, I have just put an EXIT behind the creation of Temp2 and then copied the PEEK() function out of my loop and just replaced the $(i) with a hard-coded 0 - so the syntax must be exactly the same - but inside the loop, the PEEK() function does not return a value.

Can it be that there may not be a table inbetween?

The thing is, inbetween Temp2 and my loop, I create a small dummy_table which I can append to inside the loop - but that is just one record with all the fields from the original table, but every field empty. Can that be the reason for the issue?

Thanks a lot!

Best regards,

DataNibbler

Re: Issue with PEEk

Gysbert_Wassenaar — Tue, 05 Apr 2016 08:44:51 GMT

Try adding single quotes around the table name as well: PEEK('ID', 0, 'Temp2')

Re: Issue with PEEk

datanibbler — Tue, 05 Apr 2016 08:50:31 GMT

Yep! That works.

I was very sure - but I know sometimes you just have to try out different solutions.

Thank you!

topic Re: Issue with PEEk in QlikView

Issue with PEEk

Re: Issue with PEEk

Re: Issue with PEEk