topic Re: Reg:FIFO Query in QlikView

Reg:FIFO Query

Tue, 09 Mar 2010 08:32:36 GMT

Hi All,

Wishes from Jai.I am having critical scenario this time.It is based on FIFO report which based on Inventory system.

Thing is,

1.On March 1st warehouse received 5 Items at the rate of 10.So total Price 50

2.On March 3rd warehouse received 6 Items at the rate of 5,So total price 30.

3.On March 5th warehouse got order to sell 8 items.

4.Now QlikView has to generate the report like, First 5 Items at the rate of 10 and remaining 2 items at the rate of 5.

5.So total Selling price should be (5*10)+(3*5)=65

6.If you have same kind of QVW then please share with me.

7.For more clarity here with I have atatched my qvw.

Thanks & Regards

Jai

Re: Reg:FIFO Query

antrtiz001 — Tue, 12 Aug 2014 10:25:59 GMT

Hi,

any news about this question?

I have the same problem and it would be nice to know how to solve it.

Regards

Antonio

Re: Reg:FIFO Query

jerrysvensson — Tue, 12 Aug 2014 11:28:07 GMT

Rob replied in another thread:

Is it possible FIFO in QlikView

Re: Reg:FIFO Query

antrtiz001 — Thu, 14 Aug 2014 14:29:43 GMT

I see, but it still doesn't answer to the question: data are grouped by purchase rows and costs are not reflected on the sell rows.

Any other ideas?

Regards

Antonio