Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Yolanda_R
Contributor
Contributor

Straight Tables

Good day,

I have a report that runs with an opening and closing total from 201201 on a monthly view.

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.

Any Idea on how to do this.

2 Replies
m_woolf
Master II
Master II

Try calculating the Opening and Closing Balances in script

MarcoWedel

can you please post some sample data and your expected result?

thanks

Marco