topic Re:FIFO calculation in QlikView

Re:FIFO calculation

Sat, 10 Nov 2012 05:10:04 GMT

Hi All,

I am struggling with fifo caculation can any one help me regarding this problem.

load * inline [Date,Type,Quntity

10-11-2012,purchase,30

1-11-2012,purchase,20

8-11-2012,sold,25

3-11-2012,sold,10

2-11-2012,purchase,15

] ;

This is my inline table i don't known weather it is correct table or not just i assumed if any changes are need correct me.Actuvally this is my practice example.......

Kindly need for Helpful.

Regards & Thanks,

ASHOK.

Re:FIFO calculation

Sat, 10 Nov 2012 07:53:50 GMT

Hi ashok

I don't understand your issue.

I suppose you want to use the Date ?

To transform your field Date in a usable field try this

load Date#( Date , 'DD-MM-YYYY') as Date , Type , Quntity

inline [Date,Type,Quntity

10-11-2012,purchase,30

1-11-2012,purchase,20

8-11-2012,sold,25

3-11-2012,sold,10

2-11-2012,purchase,15

] ;

Re:FIFO calculation

Sat, 10 Nov 2012 08:53:15 GMT

Hi Jean,

My issue is, if item is sold then that value is subtract from first purchase value in that date it will show remaining

value as Quntity.if sold vaiue is greaer than first purchase value then that remaining value is subtracted from second

purchased value like that..............

Thanks,

Ashok.

Re:FIFO calculation

Gysbert_Wassenaar — Sat, 10 Nov 2012 09:47:18 GMT

See attached qvw. Is that what you need?

Re:FIFO calculation

Sat, 10 Nov 2012 10:11:22 GMT

Hi Wassenaar,

Thanks for your reply,you gave me what i want.

Thanks alot.

Regards,

Ashok