Discussion Board for collaboration related to Creating Analytics for QlikView.
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
See attached example for one solution.