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: 
kalyandg
Partner - Creator III
Partner - Creator III

Inventory - Closing Stock Calculation Day by day

Hi all,

I have a issue in calculating stock, my requirement is that i need to calculate a stock(yesterday's closing stock, but from the beginning of the date(for example if i have data from 2009, it needs to calculate the stock from 01/04/2009 to 28/05/2013....it should show upto date)).

I am in need of the expression to calculate the above mentioned conditional stock.

Thank You in advance.

1 Solution

Accepted Solutions
rustyfishbones
Master II
Master II

you could try this

SUM({<Date = {"<=$(=DATE(MIN(Date)))>=$(=DATE(MAX(Date)-1))"}>} Stock

or

SUM({<Date = {"<=$(=DATE(MIN(Date)))>=$(=DATE(TODAY()-1))"}>} Stock

or chgeck out these videos on YouTube

https://www.youtube.com/playlist?list=PLCS95xQod55X286jtdiQF5FWjevJuNysW

View solution in original post

3 Replies
kalyandg
Partner - Creator III
Partner - Creator III
Author

hi

please reply anyone,,,,urgent pls....

help me

rustyfishbones
Master II
Master II

you could try this

SUM({<Date = {"<=$(=DATE(MIN(Date)))>=$(=DATE(MAX(Date)-1))"}>} Stock

or

SUM({<Date = {"<=$(=DATE(MIN(Date)))>=$(=DATE(TODAY()-1))"}>} Stock

or chgeck out these videos on YouTube

https://www.youtube.com/playlist?list=PLCS95xQod55X286jtdiQF5FWjevJuNysW

kalyandg
Partner - Creator III
Partner - Creator III
Author

hi alan,

thanks for your reply and help with those videos.

it works.

Thanks,

Kalyan