Add table in load script with calculation

[hamdaniahmad]

Hi All,

Urgently need help from all of you,

I have 3 different table (beginstock, receiving, sales) I load this table in script.

Now I want to calculate end stock with formula = (beginstock + receiving) - sales

I want stored that data daily and stored in new table (end stock) using formula when load table in script.

How I can do that with QlikView?

Thanks

I attached excel files for excel formula

[Gysbert_Wassenaar]

See attached example for one solution.