Straight table Out of memory error

[#1]

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

[Digvijay_Singh]

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.

[Anonymous]

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!