19 Replies Latest reply: May 30, 2012 7:46 AM by Sokkorn Cheav RSS

    credit debit

    Chellapilla Vinodh

      hi,

       

      i have bank transaction table like this

       

      accno transactionid      date           balance      credit-amt      debit-amt

      ------------------------------------------------------------------------------------------------------

      100     1                     11/5/12          5000          -                      -

      100     2                      15/5/12            -            400                    -

      100     3                    23/5/12             -               -                    200

      100     4                     24/5/12            -               -                    500

       

       

      this is the table .what i need the out table(it means qlikview staight table) is like this

       

      accno transactionid      date           balance      credit-amt      debit-amt     bal_amt

      --------------------------------------------------------------------------------------------------------

      100     1                     11/5/12          5000          -                      -               5000

      100     2                      15/5/12            -            400                   -               5400

      100     3                    23/5/12             -               -                    200            5200

      100     4                     24/5/12            -               -                    500             4700

       

       

      please help me as soon as possible.........

       

       

       

      Thanks

      vinodh c