if only 1.5 GB is being used, memory is not your problem (at the moment, even though you are getting pretty close). Try looking into the following:
- Open Document Properties, Sheets, and look at the sheet objects list in the bottom. Notice the objects that take most time / memory to recalculate and try to analyze what's especially heavy with those objects.
- Find "QlikView Optimizer"- it should be available in "Share QlikViews", and load your memory statistics there. Analyze your data and screen objects for the heaviest performance hits.
- One problem that I learned the hard way is that, when dealing with large data sets, QlikView seems to perform better with fewer objects on the screen (even if each object has a higher number of dimensions and expressions) than with lots of small objects (like for example numerous text objects and small sparklines on the famous Financial Controlling Dashboard). If you can convert a number of smaller objects into a single bigger object - you might gain in performance.
- If you have any macros, try to avoid those at all cost. They are hitting performance very hard on a large data set
- Watch for heavy expressions, especially involving IF statements. No matter what people might say on the forum, IF statements are prohibitive for large data sets.
whereas I am not using any macro. The object which i have finalize is as per my requirement and i cann't reduce them. if you multiply the 400,000 records into days 31 days and also transcational data is thier so the amount of data is huge here. I know the data processing will take time but it's hanging the system. Might be your qlikview optimzer help in this case. I will get back to you when i have done with the use of it.
Document Properties.PNG 29.0 K