topic Add table in load script with calculation in QlikView https://community.qlik.com/t5/QlikView/Add-table-in-load-script-with-calculation/m-p/926625#M467366 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>Urgently need help from all of you,</P><P></P><P>I have 3 different table (beginstock, receiving, sales) I load this table in script.</P><P>Now I want to calculate end stock with formula = (beginstock + receiving) - sales </P><P>I want stored that data daily and stored in new table (end stock) using formula when load table in script.</P><P></P><P>How I can do that with QlikView? </P><P></P><P>Thanks</P><P>I attached excel files for excel formula</P></BODY></HTML> Wed, 18 Nov 2015 03:41:56 GMT hamdaniahmad 2015-11-18T03:41:56Z Add table in load script with calculation https://community.qlik.com/t5/QlikView/Add-table-in-load-script-with-calculation/m-p/926625#M467366 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>Urgently need help from all of you,</P><P></P><P>I have 3 different table (beginstock, receiving, sales) I load this table in script.</P><P>Now I want to calculate end stock with formula = (beginstock + receiving) - sales </P><P>I want stored that data daily and stored in new table (end stock) using formula when load table in script.</P><P></P><P>How I can do that with QlikView? </P><P></P><P>Thanks</P><P>I attached excel files for excel formula</P></BODY></HTML> Wed, 18 Nov 2015 03:41:56 GMT https://community.qlik.com/t5/QlikView/Add-table-in-load-script-with-calculation/m-p/926625#M467366 hamdaniahmad 2015-11-18T03:41:56Z Re: Add table in load script with calculation https://community.qlik.com/t5/QlikView/Add-table-in-load-script-with-calculation/m-p/926626#M467367 <HTML><HEAD></HEAD><BODY><P>See attached example for one solution.</P></BODY></HTML> Wed, 18 Nov 2015 09:45:13 GMT https://community.qlik.com/t5/QlikView/Add-table-in-load-script-with-calculation/m-p/926626#M467367 Gysbert_Wassenaar 2015-11-18T09:45:13Z