topic 40 Mb file exceeds 3 Gigs on Task Manager in QlikView https://community.qlik.com/t5/QlikView/40-Mb-file-exceeds-3-Gigs-on-Task-Manager/m-p/363057#M134983 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>Just a quick question performance-wise. I have a request from client to produce a spreadsheet with 18 yearly tables all filtering the data in different ways.</P><P></P><P>I have a QV app with 18 bookmarks and then a copy/paste process of tables into Excel.</P><P></P><P>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.</P><P></P><P>Initially I thought it might be the bookmark set analysis, so I explicitly stated the set analysis and... same result.</P><P></P><P>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)?</P><P></P><P>Kind regards,</P><P></P><P>Cheenu</P></BODY></HTML> Mon, 23 Apr 2012 07:43:06 GMT 2012-04-23T07:43:06Z 40 Mb file exceeds 3 Gigs on Task Manager https://community.qlik.com/t5/QlikView/40-Mb-file-exceeds-3-Gigs-on-Task-Manager/m-p/363057#M134983 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>Just a quick question performance-wise. I have a request from client to produce a spreadsheet with 18 yearly tables all filtering the data in different ways.</P><P></P><P>I have a QV app with 18 bookmarks and then a copy/paste process of tables into Excel.</P><P></P><P>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.</P><P></P><P>Initially I thought it might be the bookmark set analysis, so I explicitly stated the set analysis and... same result.</P><P></P><P>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)?</P><P></P><P>Kind regards,</P><P></P><P>Cheenu</P></BODY></HTML> Mon, 23 Apr 2012 07:43:06 GMT https://community.qlik.com/t5/QlikView/40-Mb-file-exceeds-3-Gigs-on-Task-Manager/m-p/363057#M134983 2012-04-23T07:43:06Z