topic Re: How to find fifo order ? in QlikView

How to find fifo order ?

mahichowdary — Mon, 17 Aug 2015 09:53:55 GMT

Hi All,

I need Small help from you.

This is my Requirement.

Type	Id	Date	Amount
Rec	1	1/4/2015	5000
Rec	2	1/5/2015	6000
Pay	1	1/6/2015	2000
Rec	3	1/7/2015	1000
Pay	2	1/8/2015	8000

In Above table i want to fifo order in Script level.

this is my output:

Rec ID	Pay ID	Amount
1	1	2000
1	2	3000
2	2	5000

How to solve this problem.very urgent..

Waiting for u Answer..

Thanks

Mahendra

Re: How to find fifo order ?

MK_QSL — Mon, 17 Aug 2015 09:54:58 GMT

Can you explain the logic of fifo you have used ?

Where you got Rec ID and Pay ID?

Re: How to find fifo order ?

mahichowdary — Mon, 17 Aug 2015 12:19:58 GMT

Hi Manish,

Actually i have to rec amount 5000 but i have pay amount 2000, remaining 3000 is there.In Pay and rec as same id=1 and comes to pay id=2 in 8000 is there.it will pay 3000 in same rec id=1 but remaining amount is 5000 is there .here rec id =1 is complete.then come to rec id=2 under rec id=2 in amount is 6000 but i have to pay only 5000 in pay id=2,remaining 1000 is remainder.and so on...

Re: How to find fifo order ?

mahichowdary — Mon, 17 Aug 2015 12:22:56 GMT

it is an interview purpose..plz let me..

Re: How to find fifo order ?

MK_QSL — Mon, 17 Aug 2015 12:31:14 GMT

But what you explained is not matching with your output !

Can you try yourself in excel to get the same output and please attach excel file here.

Re: How to find fifo order ?

mahichowdary — Mon, 17 Aug 2015 12:36:16 GMT

k sure...i will do it ....

Thank you so much for replying...