topic Fill with previous in QlikView https://community.qlik.com/t5/QlikView/Fill-with-previous/m-p/166019#M38113 <HTML><HEAD></HEAD><BODY><P>Thanks for the comment John. The fieldvalue() idea looks interesting.</P></BODY></HTML> Tue, 02 Nov 2010 01:05:10 GMT Anonymous 2010-11-02T01:05:10Z Fill with previous https://community.qlik.com/t5/QlikView/Fill-with-previous/m-p/166017#M38111 <HTML><HEAD></HEAD><BODY><P>If anyone is interested in an example of "fill with previous" - I posted it on <A href="https://community.qlik.com/media/p/141922.aspx">Share QlikViews</A>.</P></BODY></HTML> Mon, 01 Nov 2010 00:19:26 GMT https://community.qlik.com/t5/QlikView/Fill-with-previous/m-p/166017#M38111 Anonymous 2010-11-01T00:19:26Z Fill with previous https://community.qlik.com/t5/QlikView/Fill-with-previous/m-p/166018#M38112 <HTML><HEAD></HEAD><BODY><P>I suspect that the below will execute a little faster (fieldvalue() vs. distinct, fewer joins) and use less memory (temp field vs. temp table). I also have a feeling that there's a single-step solution, but I haven't come up with anything that works.</P><P style="padding-left:30px;">RIGHT JOIN (data)<BR />LOAD<BR /> fieldvalue('Product',iterno()) as Product<BR />,recno() as Month<BR />AUTOGENERATE 12<BR />WHILE len(fieldvalue('Product',iterno()))<BR />;<BR />LEFT JOIN (data)<BR />LOAD<BR /> Product<BR />,Month<BR />,if(len(Qty)=0 and Product=peek(Product),peek(Qty2),Qty) as Qty2<BR />RESIDENT data<BR />ORDER BY Product,Month<BR />;<BR />DROP FIELD Qty;<BR />RENAME FIELD Qty2 TO Qty;</P></BODY></HTML> Mon, 01 Nov 2010 23:50:17 GMT https://community.qlik.com/t5/QlikView/Fill-with-previous/m-p/166018#M38112 johnw 2010-11-01T23:50:17Z Fill with previous https://community.qlik.com/t5/QlikView/Fill-with-previous/m-p/166019#M38113 <HTML><HEAD></HEAD><BODY><P>Thanks for the comment John. The fieldvalue() idea looks interesting.</P></BODY></HTML> Tue, 02 Nov 2010 01:05:10 GMT https://community.qlik.com/t5/QlikView/Fill-with-previous/m-p/166019#M38113 Anonymous 2010-11-02T01:05:10Z