I have a request from client to produce a spreadsheet with 18 yearly tables all filtering the data in different ways. I have a QV app with 18 bookmarks and then a copy/paste process of tables into Excel. This is not optimal and since the project and development of ad-hoc tables need to continue after my departure, I had initially chosen to try and implement 18 objects using set analysis with bookmarks (thinking it would be easier to hand-over with minimal training) and a macro doing the export into one spreadsheet.
However, this 40Mb document hangs the PC almost systematically, as when I create the set analysis charts (by about the 10th), the Task Manager shows this 40 Mb file with QV open take up 3 Gb of RAM. Initially I thought it might be the bookmark set analysis, so I explicitly stated the set analysis and... same result.
Has anyone seen this kind of QlikView "desktop" behaviour? Any explanation as to why it does this? Any workaround (apart from throwiong more RAM at the machine)?