Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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