This content has been marked as final. Show 3 replies
Hi!, I need to load data to Qlikview making some transformation, I have the folowing table at oracle:
|operation nbr||coupon||expiry date|| amount|
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|
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?
Thanks in advance!