Hi!, I need to load data to Qlikview making some transformation, I have the folowing table at oracle:
operation nbr
coupon
expiry date
amount
1001
1
4/31/13
100.00
1001
2
5/31/13
100.00
1001
3
6/31/13
100.00
1001
4
7/31/13
100.00
1001
5
8/31/13
100.00
1001
6
9/31/13
100.00
At the other hand, a have a balance value, which corresponds to the balance due (for example 600.00)
What I need is to load to Qlikview a table like below
operation nbr
coupon
expiry date
amount
balance due
1001
1
4/31/13
100.00
600.00
1001
2
5/31/13
100.00
500.00
1001
3
6/31/13
100.00
400.00
1001
4
7/31/13
100.00
300.00
1001
5
8/31/13
100.00
200.00
1001
6
9/31/13
100.00
100.00
I must to calculate the balance due month to month (balance - coupon amount). I cannot create an stored procedure at the system schema because of company policies, however I have to process record by record to calculate the balance due.
Exists a way to do that using Qlikview script language?
