topic Set Analysis and Performance in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-and-Performance/m-p/363147#M135023 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>Just a quick question performance-wise.</P><P></P><P>I have a request from a client to produce a spreadsheet with 18 yearly tables all filtering the data in different ways. I ahve 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 future developments of ad-hoc tables needs to continue after my departure, I had initally chosen to try and implement 18 objects using set analysis with bookmarks (thinking it would be easier to hand-over&nbsp; with minimal training) and a macro doing the export into one template spreadsheet.</P><P></P><P>however, this 40 Mb 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 opent taking up about 3 Gb of RAM and hanging indefinitely the PC. Initially I thought it might be the bookmark set analysis that might be more memory hungry, so I explicitly stated the set analysis and... same result.</P><P></P><P>Has anyone seen this kind of behaviour in QV Desktop (File is 40 Mb, PC has 4 Gb RAM)? Any explanation as to why it does this? Any workaround (apart from throwing more RAM at the machine)?</P><P></P><P>Kind regards,</P><P></P><P>Cheenu</P></BODY></HTML> Mon, 23 Apr 2012 08:05:42 GMT 2012-04-23T08:05:42Z Set Analysis and Performance https://community.qlik.com/t5/QlikView/Set-Analysis-and-Performance/m-p/363147#M135023 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>Just a quick question performance-wise.</P><P></P><P>I have a request from a client to produce a spreadsheet with 18 yearly tables all filtering the data in different ways. I ahve 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 future developments of ad-hoc tables needs to continue after my departure, I had initally chosen to try and implement 18 objects using set analysis with bookmarks (thinking it would be easier to hand-over&nbsp; with minimal training) and a macro doing the export into one template spreadsheet.</P><P></P><P>however, this 40 Mb 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 opent taking up about 3 Gb of RAM and hanging indefinitely the PC. Initially I thought it might be the bookmark set analysis that might be more memory hungry, so I explicitly stated the set analysis and... same result.</P><P></P><P>Has anyone seen this kind of behaviour in QV Desktop (File is 40 Mb, PC has 4 Gb RAM)? Any explanation as to why it does this? Any workaround (apart from throwing more RAM at the machine)?</P><P></P><P>Kind regards,</P><P></P><P>Cheenu</P></BODY></HTML> Mon, 23 Apr 2012 08:05:42 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-Performance/m-p/363147#M135023 2012-04-23T08:05:42Z