Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
felipeyague
Contributor II
Contributor II

Stock on date

Hello I need to have the stock on a past date, i need to sum and rest (incoming and outgoing) stock movements in order to get stock on a past date. I have all the movements but i need any way to agregate the movements prior to a date to get the stock in our plant in the selected date. Example:

 

1/1/2020 - brick initial stock: 0

1/2/2020 - incoming brick + 10

1/3/2020 - incoming brick + 10

1/4/2020 - incoming brick + 10

If i ask for stock on 20/3/20 i should get 20

Current stock is 30. 

Any help? thanks.

 

0 Replies