https://community.qlik.com/t5/App-Development/Year-wise-Opening-and-closing-balance/m-p/1833358#M68796 <P>Dear All<BR /><BR />we need year wise opening balance and closing balance in one straight table ,for that purpose we have three separate tables one is master calendar and other one is transaction table_1 which has opening balance and table_2 which has closing balance now we want to pick approval year from master calendar opening from table_1 and closing from table_2 . master calendar has no link with&nbsp; any of transaction table</P><P>we have shared some sample data also .</P><P>can any one please solve this .</P> Thu, 02 Sep 2021 18:21:47 GMT aamir_bhellar 2021-09-02T18:21:47Z https://community.qlik.com/t5/App-Development/Year-wise-Opening-and-closing-balance/m-p/1833358#M68796 <P>Dear All<BR /><BR />we need year wise opening balance and closing balance in one straight table ,for that purpose we have three separate tables one is master calendar and other one is transaction table_1 which has opening balance and table_2 which has closing balance now we want to pick approval year from master calendar opening from table_1 and closing from table_2 . master calendar has no link with&nbsp; any of transaction table</P><P>we have shared some sample data also .</P><P>can any one please solve this .</P> Thu, 02 Sep 2021 18:21:47 GMT https://community.qlik.com/t5/App-Development/Year-wise-Opening-and-closing-balance/m-p/1833358#M68796 aamir_bhellar 2021-09-02T18:21:47Z