Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

New Contributor III

Add table in load script with calculation

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?


I attached excel files for excel formula

1 Reply

Re: Add table in load script with calculation

See attached example for one solution.

talk is cheap, supply exceeds demand
Community Browser