topic Peek function in QlikView

Peek function

charlotte_qvw — Fri, 02 Aug 2013 11:02:26 GMT

Can anyone help me with this script? I can't work out why amount is copying down only once, but not to any subsequent rows. If amount is null at all I would like to have the previous non null amount for an id copied down, but with my script it's only copying down to the first null line. Here is the script. many thanks

t1:

LOAD * Inline [

id, amount

1, 100

1, 400

2, 500

2, ];

t2:

NoConcatenate LOAD

id,

if(previous(id)=id, peek('amount'), amount) as amount2,

amount

Resident t1 order by id asc;

DROP Table t1;

Re: Peek function

tresB — Fri, 02 Aug 2013 11:04:40 GMT

try:

if(previous(id)=id, peek('amount2'), amount) as amount2

Re: Peek function

charlotte_qvw — Fri, 02 Aug 2013 11:08:14 GMT

Thanks v much! after i wrote the question i just worked that out!

Re: Peek function

Fri, 02 Aug 2013 11:09:12 GMT

like tres qv try this

if(previous(id)=id, peek('amount2'), amount) as amount2