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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Phan_Anh_Son
Partner - Contributor III
Partner - Contributor III

Inventory Open/Closing/Balances

Hi all,

Can someone help to advise how to compute inventory Opening and Closing balances across month and year.

Thanks !!!!!!!

 

Labels (1)
2 Replies
marksouzacosta

Hi @Phan_Anh_Son,

What is the definition for Opening Balance and Ending Balance?

Is Ending Balance not just Sum(PVolume)-Sum(SVolume) - Purchased minus Sold?


Regards,

Mark Costa

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

Phan_Anh_Son
Partner - Contributor III
Partner - Contributor III
Author

Good Morning Marksouzacosta:

Opening Balance is the previous period's balance according to Product, year, month,...
and Ending Balance = Opening + Purchased - Sales

Thanks.