topic Re: LET variable = PEEK('field1', 0, 'MyTable') not giving a value in QlikView

LET variable = PEEK('field1', 0, 'MyTable') not giving a value

Fri, 21 Sep 2012 16:05:21 GMT

Hi community,

I used the above code to store the value of a field of a table into a variable, the field only has one value, 2012. Any ideas as to why this might be giving me nothing? Am I missing something in the syntax?

Re: LET variable = PEEK('field1', 0, 'MyTable') not giving a value

Anonymous — Fri, 21 Sep 2012 16:19:34 GMT

Brandon,

I don't see anything wrong. See the attched, compare with your application.

Regards,

Michael

Re: LET variable = PEEK('field1', 0, 'MyTable') not giving a value

Fri, 21 Sep 2012 16:31:07 GMT

Very Bizarre,

I works just fine when the table the variable comes from is from an inline table, but not when the table is loaded from a qvd. In fact, the variable doesn't even show up in the document (when I try to put it as a variable in an input box.) after a reload unless it was already created.

Re: LET variable = PEEK('field1', 0, 'MyTable') not giving a value

Anonymous — Fri, 21 Sep 2012 19:06:13 GMT

It works for me with QVD load as well.

Are you sure that you do not delete your variable later in the script?

Re: LET variable = PEEK('field1', 0, 'MyTable') not giving a value

alexpanjhc — Fri, 21 Sep 2012 21:31:50 GMT

i am trying to think, maybe when you actually used this value, did you use $(variable)?

try debug reload see what that value is.

Re: LET variable = PEEK('field1', 0, 'MyTable') not giving a value

swuehl — Fri, 21 Sep 2012 22:05:32 GMT

I believe the variable will not be created if the expression evaluates to NULL.

And QV won't give an error message if this happens.

Have you checked that table and field name are spelled correctly?

You can try, if these lines return any data:

Let vVar1 = peek('field',0,'MyTable');

Let vVar2 = FieldValue('field',1);

Let vVar3 = NoOfRows('MyTable');

Let vVar4 = FieldValueCount('field');

Would it be possible that you post your script code here?

Regards,

Stefan

Re: LET variable = PEEK('field1', 0, 'MyTable') not giving a value

Fri, 21 Sep 2012 22:09:49 GMT

I'm not going to lie folks. I did find a work around but come Tuesday when I get back, I'll test your suggestions and post the document here too.

Re: LET variable = PEEK('field1', 0, 'MyTable') not giving a value

Fri, 21 Sep 2012 22:26:11 GMT

Attached is the file with the oddity.

Re: LET variable = PEEK('field1', 0, 'MyTable') not giving a value

swuehl — Fri, 21 Sep 2012 22:55:51 GMT

If I got it right, your MyTable has only one value in one row, but 19 rows in total, most of them NULL.

Peek() addresses a certain row in that table, but the first rows are all NULL, that's why you don't get a result back for your variable.

Let vVar2 = FieldValue('field',1);

does work in that case.

Hope this helps,

Stefan

Re: LET variable = PEEK('field1', 0, 'MyTable') not giving a value

berndjaegle — Wed, 07 Jan 2015 08:42:38 GMT

Hi Brandon,

had a similar issue, but in my case just 'quotes' were missing...

wrong: peek(field,0,MyTable);

right: peek('field',0,'MyTable');

Not the answer to your question, but might be helpful for others.

Regards,

Bernd

Re: LET variable = PEEK('field1', 0, 'MyTable') not giving a value

rvrj — Mon, 11 Mar 2019 12:34:52 GMT

@berndjaegleYou're a life-saver! Many thanks!