Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

kalyandg
Contributor II

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
Highlighted
rustyfishbones
Honored Contributor II

Re: Inventory - Closing Stock Calculation Day by day

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

3 Replies
kalyandg
Contributor II

Re: Inventory - Closing Stock Calculation Day by day

hi

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

help me

Highlighted
rustyfishbones
Honored Contributor II

Re: Inventory - Closing Stock Calculation Day by day

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
Contributor II

Re: Inventory - Closing Stock Calculation Day by day

hi alan,

thanks for your reply and help with those videos.

it works.

Thanks,

Kalyan

Community Browser