topic last cost in QlikView https://community.qlik.com/t5/QlikView/last-cost/m-p/225921#M78176 <HTML><HEAD></HEAD><BODY><P>hi, this is my facts table</P><TABLE><TBODY><TR><TD>ID</TD><TD>date</TD><TD>type</TD><TD>item</TD><TD>quantity</TD><TD>cost</TD><TD>revenue</TD></TR><TR><TD>1</TD><TD>17/11/09</TD><TD>sell-in</TD><TD>8410</TD><TD>2</TD><TD>230</TD><TD></TD></TR><TR><TD>2</TD><TD>30/11/09</TD><TD>sell-out</TD><TD>8410</TD><TD>1</TD><TD></TD><TD>280</TD></TR><TR><TD>3</TD><TD>30/11/09</TD><TD>sell-out</TD><TD>8410</TD><TD>1</TD><TD></TD><TD>280</TD></TR><TR><TD>4</TD><TD>17/12/09</TD><TD>sell-in</TD><TD>8410</TD><TD>1</TD><TD>220</TD><TD></TD></TR><TR><TD>5</TD><TD>18/12/09</TD><TD>sell-out</TD><TD>8410</TD><TD>1</TD><TD></TD><TD>280</TD></TR></TBODY></TABLE><P>whow can I update the cost in all sell-out row with the last sell-in value? this is for valuate stock with last cost value.</P><P>thanks all</P></BODY></HTML> Thu, 28 Jan 2010 18:33:24 GMT 2010-01-28T18:33:24Z last cost https://community.qlik.com/t5/QlikView/last-cost/m-p/225921#M78176 <HTML><HEAD></HEAD><BODY><P>hi, this is my facts table</P><TABLE><TBODY><TR><TD>ID</TD><TD>date</TD><TD>type</TD><TD>item</TD><TD>quantity</TD><TD>cost</TD><TD>revenue</TD></TR><TR><TD>1</TD><TD>17/11/09</TD><TD>sell-in</TD><TD>8410</TD><TD>2</TD><TD>230</TD><TD></TD></TR><TR><TD>2</TD><TD>30/11/09</TD><TD>sell-out</TD><TD>8410</TD><TD>1</TD><TD></TD><TD>280</TD></TR><TR><TD>3</TD><TD>30/11/09</TD><TD>sell-out</TD><TD>8410</TD><TD>1</TD><TD></TD><TD>280</TD></TR><TR><TD>4</TD><TD>17/12/09</TD><TD>sell-in</TD><TD>8410</TD><TD>1</TD><TD>220</TD><TD></TD></TR><TR><TD>5</TD><TD>18/12/09</TD><TD>sell-out</TD><TD>8410</TD><TD>1</TD><TD></TD><TD>280</TD></TR></TBODY></TABLE><P>whow can I update the cost in all sell-out row with the last sell-in value? this is for valuate stock with last cost value.</P><P>thanks all</P></BODY></HTML> Thu, 28 Jan 2010 18:33:24 GMT https://community.qlik.com/t5/QlikView/last-cost/m-p/225921#M78176 2010-01-28T18:33:24Z last cost https://community.qlik.com/t5/QlikView/last-cost/m-p/225922#M78177 <HTML><HEAD></HEAD><BODY><P>I think the right practice is:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">LOAD *,if(cost,cost,previous(last_cost)) as last_cost resident TB1</PRE></BLOCKQUOTE><BR /><BR /> <P>but it's not possible in QV</P></BODY></HTML> Thu, 28 Jan 2010 18:40:24 GMT https://community.qlik.com/t5/QlikView/last-cost/m-p/225922#M78177 2010-01-28T18:40:24Z