topic Inventory - Closing Stock Calculation Day by day in QlikView

Inventory - Closing Stock Calculation Day by day

kalyandg — Wed, 29 May 2013 09:56:34 GMT

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.

Re: Inventory - Closing Stock Calculation Day by day

kalyandg — Sun, 02 Jun 2013 05:21:43 GMT

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

help me

Re: Inventory - Closing Stock Calculation Day by day

rustyfishbones — Sun, 02 Jun 2013 08:21:03 GMT

you could try this

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

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

or chgeck out these videos on YouTube

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

Re: Inventory - Closing Stock Calculation Day by day

kalyandg — Mon, 03 Jun 2013 04:08:13 GMT

hi alan,

thanks for your reply and help with those videos.

it works.

Thanks,

Kalyan