topic Re: Out of object memory issue in QlikView

Out of object memory issue

Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I need to show vendor details in a straight table. Since I have huge record I am getting out of object memory error.

Can anyone suggest me the best approach to do the same.

Thanks,

Prajna

Clever_Anjos — Tue, 30 Aug 2016 13:03:41 GMT

You can use:

Review your expressions and dimensions
Create a calculation condition to force your users to make some selections before calculation
Use Max number at Presentation tab

Peter_Cammaert — Tue, 30 Aug 2016 13:10:38 GMT

Millions of vendors? Seems unlikely...

Can you provide some more details about your data model and what you are showing in your straight table?

vinieme12 — Tue, 30 Aug 2016 13:15:33 GMT

can you post your calculated dimensions if any and your expressions

kuczynska — Tue, 30 Aug 2016 13:39:53 GMT

If you must display transaction data in the straight table try from the basics - just like guys before me said:

- if any calculated dimension - move to the back end (if possible)

- confirm with users if they are using all of the dimensions (especially long text strings)

- if possible - get ready expressions that aren't used (confirm with users)

- think about reducing some set analysis, simplifying set modifiers to number rather than text

- maybe move your expressions to variables menu?

and most important - force some user selections before accessing this tab to narrow down the data set!

ger_alegria — Tue, 30 Aug 2016 21:36:20 GMT

Review your expresions. Maybe you are using an if and this affects the behavior of your object.