topic Re: Straight table Out of memory error in QlikView

Straight table Out of memory error

Tue, 17 Jan 2017 15:37:40 GMT

Hi everyone,

I'm struggling with a straight table throwing 'Object out of memory' error. It has around 10 dimensions and 5 expressions.

5 dimensions are calculated dimensions. The expressions do involve set analysis and few nested if statements, I assume this is

what's causing it to slow down. If I have the dimensions selected the figures seem correct, but when i clear all selections and leave the chart to

populate on it's own, it doesn't load, the memory seems to max out everytime.

Can someone please suggest a fix for this? I have tried optimizing the expressions, which didn't seem to have any effect so far.

TIA

Re: Straight table Out of memory error

Digvijay_Singh — Tue, 17 Jan 2017 16:30:53 GMT

You may think of moving some of the calculation at script level, also in case of many dimensions and expressions, pivot is considered better. Check if nested if can be converted to pick/match..You can find many related posts in the community to improve the performance at data model and UI level.

Re: Straight table Out of memory error

Anonymous — Tue, 06 Jun 2017 22:17:10 GMT

I use many Set Analysis and pick/match in the app. There is no synthetical key in my data model.

However, Out of calculation memory happens to a table and a map in the Qlik app.

Any suggestion?

Thanks!