topic Re: Using PEEK function with " double quotes in QlikView

Using PEEK function with " double quotes

rustyfishbones — Tue, 10 Oct 2017 16:07:51 GMT

Hi All,

I have the following peek function

let vLastRecord = PEEK('generated_timestamp',-1,'MasterTable') ;

But the Variable does not get populated.

I think it's because in the table the filed is "generated_timestamp"

If I try

let vLastRecord = PEEK('"generated_timestamp"',-1,'MasterTable') ;

or try

let vLastRecord = PEEK('[generated_timestamp]',-1,'MasterTable') ; neither work

Sergey_Shuklin — Tue, 10 Oct 2017 16:18:28 GMT

Hello, Alan!

Is there everything ok with field names? And '-1' will return the last readed record value, maybe there is some inappropriate value?

sunny_talwar — Tue, 10 Oct 2017 16:20:49 GMT

Have you checked the name of the field after the reload completes? Is it generated_timestamp or "generated_timestamp"

rustyfishbones — Tue, 10 Oct 2017 16:27:21 GMT

It's generated_timestamp

sunny_talwar — Tue, 10 Oct 2017 16:28:57 GMT

So, then your issue is something else (and not the double quotes)... what if you try this?

let vLastRecord = PEEK('generated_timestamp') ;

rustyfishbones — Tue, 10 Oct 2017 16:31:25 GMT

I have tried that already and still it does not populate the VARIABLE.

It works when I store the Data into a qvd, drop the original table and when I reload the qvd, the variable gets populated.

But not on the original extraction of data.

sunny_talwar — Tue, 10 Oct 2017 16:33:07 GMT

What is the exact script before this variable?

pradosh_thakur — Tue, 10 Oct 2017 17:04:39 GMT

let vLastRecord = PEEK('"generated_timestamp"',-1,'MasterTable') ; is working for me . i tried something similar with the data base too.

can you please check if there is any space.

Can you share the line where "generated_timestamp" is extracted from dtaabase to qvw?

is it like expression as ["generated_timestamp"] or something else?

regards

Pradosh