Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with Peek

Hi Friends,

I have a problema because

use this cicle

for con=1 to 58

tem:

load

A as A1

resident Fechacargas

where id=$(con);

let max2=peek('A1',0,'tem');

load * inline[

sta

$(max2)

];

next

but only  charges in the load inline the first value.

Any idea for take the value of the actual row(id)?

best regards.

1 Solution

Accepted Solutions
Not applicable
Author

After the peek statment drop the table tem

drop table tem ;

So data will not be appended to tem..

View solution in original post

2 Replies
Not applicable
Author

After the peek statment drop the table tem

drop table tem ;

So data will not be appended to tem..

maxgro
MVP
MVP

I think when you load tem you concatenate Fechacargas and peek will always return the same value (the first one)

you can try dropping tem before next

or

with peek('A1',-1,'tem') to get the last value