Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Inventory FIFO Calculation

Hi everyone,

I have an issue on calculating inventory out value.

I have attached the excel file please find the details on it.

thanks,

5 Replies
Highlighted
MVP
MVP

Re: Inventory FIFO Calculation

You have to explain how you have calculated in excel. Otherwise there is very rare chance you will get reply..

Highlighted
Contributor III

Re: Inventory FIFO Calculation

Thanks for your reply,

I need to calculate first in quantity values should be carry to first quantity values, if i buy 5 watches 10rs as a unit price of watch, then i sold 3 watches that out value should be from buy value.

Highlighted
MVP
MVP

Re: Inventory FIFO Calculation

Provide this in Calculated Way in Excel..

I mean keep the formula there in excel to understand.

Highlighted

Re: Inventory FIFO Calculation

Manish -

I have added the FIFO logic in the Excel. I think the dates are kind of misleading here, but I think you will see the logic. BTW if you don't already know, FIFO is First In First Out. The inventory which came in first needs to be sold first before we sell the newer inventory.

Highlighted
Contributor III

Re: Inventory FIFO Calculation

Thank you sunny  exactly you have understood what i want.