Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
aamir_bhellar
Partner - Contributor II
Partner - Contributor II

Year wise Opening and closing balance

Dear All

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  any of transaction table

we have shared some sample data also .

can any one please solve this .

0 Replies