https://community.qlik.com/t5/QlikView/Straight-Tables/m-p/1531188#M747804 <P>Good day,</P><P>I have a report that runs with an opening and closing total from 201201 on a monthly view.</P><P>When doing a straight table, it gets very lengthy and was wondering if there is a way to not show months 201201 to 201809 and show only from 201810 on words, but the opening balance starting from 201810 pulls from the closing balance on previous months, thus taking these columns away changes the values in opening and closing balances of the report.</P><P>Any Idea on how to do this.</P> Wed, 25 Nov 2020 16:16:04 GMT Yolanda_R 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Straight-Tables/m-p/1531188#M747804 <P>Good day,</P><P>I have a report that runs with an opening and closing total from 201201 on a monthly view.</P><P>When doing a straight table, it gets very lengthy and was wondering if there is a way to not show months 201201 to 201809 and show only from 201810 on words, but the opening balance starting from 201810 pulls from the closing balance on previous months, thus taking these columns away changes the values in opening and closing balances of the report.</P><P>Any Idea on how to do this.</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Straight-Tables/m-p/1531188#M747804 Yolanda_R 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Straight-Tables/m-p/1531197#M747805 <P>Try calculating the Opening and Closing Balances in script</P> Wed, 16 Jan 2019 17:29:16 GMT https://community.qlik.com/t5/QlikView/Straight-Tables/m-p/1531197#M747805 m_woolf 2019-01-16T17:29:16Z https://community.qlik.com/t5/QlikView/Straight-Tables/m-p/1531273#M747806 <P>can you please post some sample data and your expected result?</P><P>thanks</P><P>Marco</P> Wed, 16 Jan 2019 21:16:40 GMT https://community.qlik.com/t5/QlikView/Straight-Tables/m-p/1531273#M747806 MarcoWedel 2019-01-16T21:16:40Z