Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hamdaniahmad
Contributor III
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?

Thanks

I attached excel files for excel formula

1 Reply
Gysbert_Wassenaar

See attached example for one solution.


talk is cheap, supply exceeds demand