Cash Flow Statment In Qlik sense

[mariamovasheli]

Hello, 

I am preparing Cash Flow  Statement In Qlik Sense And I have problems Showing Opening and Ending balance for every period that can be selected. I want to Show this Statement as Table with drill down dimension of Date. Can you help me with any advice or formulas how can i calculate opening balance and ending balance and show it in table as a dimension.

for example for January opening balance will be ending balance of 31 of  December. and ending balance for 31 of December is sum of all transactions till 31 of December. 

[dplr-rn]

It depends on your data model and other items. But in general using set analysis with an asof table will be ideal for such scenarios
https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130