Inventory aging buckets

[kaldubai]

Dears,

I'm working on inventory aging and i have been trying to distribute QTY & cost  based on receiving dates.

the problem is :

lets assume that i have 19 pieces of item A as on hand and on the other hand i have received this item on mulitpule dates & QTY (Total recievd 42 ,and 23 have been sold before the selected date  )

the user will select 12/dec/2017 as of that date, i have 19 qty out of 42 received From item A , and this item has been received on the following dates

Received date	QTY Received	Selected date -Recv Date	Buckets	On Hand Qty
28/Nov/2017	1	33	0-60	1 of 19
25/Nov/2017	1	36	0-60	1 of 19
14/Jun/2017	10	200	180-365	10 of 19
13/Jun/2017	13	201	180-365	7 of 19

is it possible to be done in qlik.

[stevedark]

Allowing the user to pick the date will not make this easy at all.  You will need to be using the Above statement, and probably some Aggr statements.

How many days back do you want to allow the user to go?  You may be able to do something in the load script if it is just a few days rather than them being able to pick any date.

Steve

[kaldubai]

what i understand from you that if the user is given the leverage to pick any date will make this hard to achieve, but if we are looking at as of current date it can be done ??

[stevedark]

Exactly.  If it is based on current date, as at time of data reload, then all the elements you should need are in the code I provided above.  If it is dynamic in the front end then if it can be coded for it will perform very badly.

[kaldubai]

Thanks alot Steve for your feedback. i will keep on working on this case and will update this thread once its all settled down

[shruti090]

Hello, I have tried using formula but in the if statement it is always considering the false value

[ben_skerrett]

kaldubai did you manage to resolve the issue as I have pretty much the same requirement please?

Thanks