Inventory Ageing For Multiple Materials

[satish25]

Hello QlikExperts,

     I wanted to find the "Inventory Ageing" in Buckets for Different Materials ranging from 0-30 Days, 31-60 Days, 61-90 Days, 91-120 Days, 121-150 Days, 151-180 Days, 181-270 Days, 271-365 Days, 366-730 Days, and >730 Days. The Quantities in the Ageing  should be in FIFO (First In First Out) basis.

     'Debit' is "Ordered In" and 'Credit' is "Sold Out"

     So Debit will always be Greater than or Equal to Credit.

     The Date Format is in 'MM/DD/YY'.

     I am attaching a part of the data as a screenshot below.

The Output shown must be as follows which is shown above.

The Material Quantities are (Debit-Credit).

[sunny_talwar]

So, I guess you need to figure out what changed between Excel load and SAP load. Is the Document Date read as a date field? Look here

Why don’t my dates work?

QlikView Date fields

Get the Dates Right