3 Replies Latest reply: Sep 11, 2013 2:00 PM by amy li RSS

    Data transformation alternatives using Qlikview

      Hi!, I need to load data to Qlikview making some transformation, I have the folowing table at oracle:

       

       

       

       

      operation nbr
      coupon
      expiry date
      amount
      100114/31/13100.00
      100125/31/13100.00
      100136/31/13100.00
      100147/31/13100.00
      100158/31/13100.00
      100169/31/13100.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
      100114/31/13100.00600.00
      100125/31/13100.00500.00
      100136/31/13100.00400.00
      100147/31/13100.00300.00
      100158/31/13100.00200.00
      100169/31/13100.00100.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?

       

      Thanks in advance!