Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Memory issue for opening a large document

Hi,

I have a qvw file which is around 1gb in this format. When I try to load it on the Qlikview desktop the process takes up almost 80gb

Can someome suggest a way to reduce this. I am expecting a lot more data and the system doesnot load after 101-102gb.

Thanks

3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You can open it without data to do design modifications. If you need some data for design, you can then do a limited load uisng the debugger.

A downside of limited load is that you don't necessarily get linked records. An alternative is to keep a data reduced version of the dashboard around and use that version to do the design work. If you have Publisher, set up a reduce task that limits data to something like Region. Run that task when you need to make a fresh reduced copy from the master.

-Rob

http://robwunderlich.com

Not applicable
Author

My problem is not the loading but Qlikview memory utilization. When I open the document it still uses the complete 80gb instead of a smaller version.

I do not want it to utilize all this memory since my server crashes at 101gb

swuehl
MVP
MVP

I would assume that your data model itself will not take that much of the memory.

What if you create a new qvw document and do a binary load of your original qvw? How much RAM will be used?

I assume that you are using some (or a lot of) chart objects with complex expressions. Could this be the case?

You can open your original qvw without any data (there is an option e.g. in Start page to open a recently opened document without data). Then copy your chart objects to the new qvw (the one with the binary load), one after the other and watch your RAM to identify the problematic chart.

Try to redesign your expressions, if possible (e.g. by creating flags in the script).

Hope this helps,

Stefan