topic exceeded the allocated memory in QlikView

exceeded the allocated memory

Thu, 04 Feb 2010 18:35:33 GMT

Hello experts,

Sometimes working on a document I get the message "exceeded the allocated memory".

What it means and how can i solve it ?

Thanks in advance for your time.

Best regards

exceeded the allocated memory

Oleg_Troyansky — Thu, 04 Feb 2010 19:29:39 GMT

This can be caused by many different reasons:

- wrongly linked tables causing Cartesian product;

- overly detailed Straight Tables or Pivot Tables with thousands of rows

- extensive use of IF functions within chart expressions

- the list goes on...

For starters, check the "Memory" settings in the Document Properties. If you have a decent hardware, you should check the checkbox "ignore the limits", to allow QlikView calculating charts practically without limits.

Also, check "Document Properties", tab "Sheets" and look for Objects (in the bottom of the dialog box) with the highest Memory use. Try to understand what might be wrong about those particular objects.

cheers,

exceeded the allocated memory

Fri, 05 Feb 2010 11:17:52 GMT

in what document properties tab is the checkbox "ignore the limits" ?

exceeded the allocated memory

Fri, 05 Feb 2010 11:24:00 GMT

taking a look at the bottom of Document properties->sheets it shows 0 KB for all objects except for one (35 KB).

is it corrects or is there something strange (0 KB) ?