Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error Memory

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.

8 Replies
sparur
Specialist II
Specialist II

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

Not applicable
Author

Yes i had this check box selected.

but it doen't show me the pivot table

sparur
Specialist II
Specialist II

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.

Not applicable
Author

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??

Not applicable
Author

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....

sparur
Specialist II
Specialist II

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).

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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!

Not applicable
Author

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.