topic Error Memory in QlikView

Error Memory

Thu, 08 Apr 2010 10:11:11 GMT

I had version 8.01

i had a pivot table that always gives me Object memory exceded.

I have seen that there is a button in General Tab of the pivot table called Memory. But it is always disabled...

FOr what is this button used for??

And who can i enabled it??

Thanks.

Error Memory

sparur — Thu, 08 Apr 2010 10:31:08 GMT

Hello

in QV 9.0:

Settings-> User Prefs-> Objects tab - > "Ignore calculation limits" check box

I think your version at the same.

this option let create limit by memory in each chart object

Error Memory

Thu, 08 Apr 2010 10:58:45 GMT

Yes i had this check box selected.

but it doen't show me the pivot table

Error Memory

sparur — Thu, 08 Apr 2010 11:05:09 GMT

If you UNcheck this option (Ignore Calculation Limits) so you will get possible to limit for memory in each chart (pivot, as the same). i.e. "Memory" button on general tab in pivot properties will be enabled.

Error Memory

Thu, 08 Apr 2010 11:30:56 GMT

i dont know what i have done but know i have this message always when memory is exceded

How can i do to dont see it more??

Error Memory

Thu, 08 Apr 2010 11:41:35 GMT

Hi,

I hope these points you should consider, if you get like this error.

1) Proper Data Mapping is require.

2) Try to avoid more synthetic keys..

3) Depends on your system RAM..

Regards,

Ravi....

Error Memory

sparur — Thu, 08 Apr 2010 11:44:38 GMT

You can limit of memory for your chart (by press memory button in General tab of properties) and then fill Error messages "Out of object memory" (press 'Error messages..." button in General tab).

Error Memory

Oleg_Troyansky — Fri, 09 Apr 2010 05:45:11 GMT

Pivot Tables are pretty heavy objects (perhaps the heaviest in QlikView), and they can easily go out of memory if you have Dimensions with too many values, or heavy Calculated Dimensions, or heavy expressions with IF statements. Some of the things to consider:

- get rid of any IF conditions in Expressions and Calculated Dimensions

- avoid Dimensions that are too detailed

- If you have to use very detailed Dimensions, request that the User makes certain selections to narrow down the data set. You can do it using Calculation Condition (Properties, General Tab). Only show the table if a single Customer, or Product or whatever else is selected...

good luck!

Error Memory

Fri, 09 Apr 2010 08:43:06 GMT

What is get rid of any IF conditions in Expressions and Calculated Dimensions?? i don´t know too mcuh english sorry.

The other answer i had understood.