Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
malradi88
Creator II
Creator II

Cashflow Query Opening & Closing Balance

Dear Qlik Community,

I am currently attempting to create a cashflow based on data that resembles the attached document. A simple income table and Expenditure table. If I know that the opening balance is 15000 at the start of august (first month in the dataset), how can i create a cashflow like table that has 'opening balance' on the first row and 'closing balance' on the last row.

As we know that 15000 is the opening is there anyway of instructing qlik to add all income from the month and subtract expenses to figure out the closing balance at the bottom, then have that closing balance carry to the top of the next month etc...?

Thank you for your support. Unfortunately the dataset I am working does not work in very granular dates (Days) so I cannot create a journal with a balance column. Hopefully I can convince the people I am working to move towards a journal format.

Best,

Mohammed

2 Replies
sunny_talwar

ogster1974
Partner - Master II
Partner - Master II

Here is an example with your data to get you started.

Has a table with your opening, In, out and closing columns.

Regards

Andy