Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor

Stock Ageing Report in FIFO manner.

Hi All,

           I have a problem in creating a Stock Aging. I have three files named Old, New and Sale.

I need to create an Aging report in the form of FIFO (First in First Out)

Old file has data till 2014, while new has the data from the current year till date.

Old file.                                                                                                                New File

Product Id,             Qty,      Posting date.                                      Product ID,                  Qty,                  Posting date

P1.                         10           20/5/2014                                             P1.                          10           2/1/2015

P1.                          5              23/6/2014                                            P1.                          10           4/2/2015             

P2.                          5              23/6/2014                                            P2.                          20           1/3/2015

  1. Sale.

Product Id,           Qty,      Sale Posting date.

P1.                          5              2/2/2015

P1.                          3              3/2/2015.                                            

Output

Product Id,   (Remaining)Qty,  Posting date.              Sale Posting date

P1.                   5                          20/5/2014                      2/2/2015

P1                   2                               20/5/2015            3/2/2015

That is in sale if the quantity is 10, then in the remaining quantity field it should  be      P1          0          20/5/2014     Sales Posting date.

Regards

Rahul.S

4 Replies
Highlighted
Esteemed Contributor

Re: Stock Ageing Report in FIFO manner.

Hii

Please check if attached file is useful for you

Vikas

Highlighted
Contributor

Re: Stock Ageing Report in FIFO manner.

Hi Vikas,

didn't get ur attachment

regards

Highlighted
Esteemed Contributor

Re: Stock Ageing Report in FIFO manner.

PFA

Vikas

Highlighted
Contributor

Re: Stock Ageing Report in FIFO manner.

Hi Vikas,

Thanks for your quick reply. But this was not I wanted.

Actually I need a table which shows deduction of those data which came into inventory first.

Suppose stock has entered in JAN, FEB, Mar.

the stock of Jan should cleared first, then of feb and then of March.