Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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 ??
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.
Thanks alot Steve for your feedback. i will keep on working on this case and will update this thread once its all settled down
Hello, I have tried using formula but in the if statement it is always considering the false value
kaldubai did you manage to resolve the issue as I have pretty much the same requirement please?
Thanks