Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have a qvw that is 2.5 gb in size. When I try to open the file in qlikview it hangs my computer.
I am on Windows 10
Desktop Client: 12.1 SR1
RAM on my computer: 12GB Processing Power
Note: I have been ale to access the application before. I am not sure what is happening now.
Please advise on what should I do?
Thanks
Rizwan Syed
Take a look on the compressing-settings of this application then if this application is compressed it might be a lot bigger within the RAM - depending on the kind of data within it it could be easily a factor of 8 which would lead to a real filesize of 20 GB and which is more than you have on RAM.
To open the application you could open them without data:

and then to check the compression setting and then to reload the application within the debugger with a reduced number on records and afterwards you could check the datamodel to synthetic keys, the use of the document analyzer from Rob Wunderlich and some other things too - to optimize your application.
If there is really not much to optimize you will need more ressources on (CPU and) RAM to handle it.
- Marcus
Whow!! I can't believe that you use this amount of data.
You can try to compress the file with the 'High' option in Document properties, but with this set of data maybe you must try to delimit your data by dates (years for examples), do a clean of your data set removing the columns or data that you don't use it.
Regards