topic Re: Problem with Peek in QlikView

Problem with Peek

Mon, 06 Oct 2014 19:42:46 GMT

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)

];

but only charges in the load inline the first value.

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

best regards.

Mon, 06 Oct 2014 20:01:16 GMT

After the peek statment drop the table tem

drop table tem ;

So data will not be appended to tem..

maxgro — Mon, 06 Oct 2014 20:06:13 GMT

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

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