Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

malradi88
Contributor

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

Re: Cashflow Query Opening & Closing Balance

ogster1974
Honored Contributor II

Re: Cashflow Query Opening & Closing Balance

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

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

Regards

Andy

Community Browser