Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Leverage your QlikView investment to modernize BI – see how! Join Group
Showing results for 
Search instead for 
Did you mean: 

Balance on a particular day

I would like to look into the best way to deal with transaction (Balance) data in QlikView. 

We have the Following Scenario:

Customer A Takes out a Loan on a date in the past, each day Interest is charged to the load, and on certain days Repayment may be made, and other charges may also be made:

1/1/2013 - Load Taken out £100 - Balance £100

2/1/2013 - Interest Charged £1

3/1/2013 - Interest Charged £1

4/1/2013 - Interest Charged £1

5/1/2013 - Interest Charged £1

6/1/2013 - Interest Charged £1

6/1/2013 - Payment Made £50 - Balance £56

7/1/2013 - Interest Charged £.50

8/1/2013 - Interest Charged £.50

9/1/203 - Payment Made £57

What we need to be able to do is understand a balances and sum of balances at a point of time, (i.e. Cumulative), and would like to know the best way to do this. 

Tags (2)