Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

first in frist out

hi  can anyone help me

i have a table like below

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

i need o/p like this

recID  pay ID   amount

1          1             2000

1           2             3000

2           2             5000

14 Replies
MK_QSL
MVP
MVP

Whatever you are explaining, can you provide this in figure... Like...

5000 - 2000 = 3000

3000 + 6000 - 8000 = 1000 etc..

Don't write in words.. It's difficult to understand. Provide by calculation.. I will work on this for you..!

nareshthavidishetty
Creator III
Creator III
Author

@

nareshthavidishetty
Creator III
Creator III
Author

i have attached my file kindly have a look

MK_QSL
MVP
MVP

But Calculation is Missing... !

nareshthavidishetty
Creator III
Creator III
Author

(1) rec id   5000 but payment is 2000 for same id (1) but here remainder is 3000  think ur still in( tran 1)  thats y

recid  payid amount

1         1        2000

1         2        3000 (remainder)

but in second payment u need to pay 8000 here 3000 is paid by trans 1 so still 5000 should be paid right

recid        pay id           amount

2              2                  5000

2              2                   1000   as  received am is 6000 but 5000 already present so remainder is 1000 for the same transaction like wise it shold follow the loop