Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to avoid 'Allocated Memory Exceeded' issue?

Hi All

     I have a chart:

2 Dimensions:  both are Cyclic group: Grp_Geo (geography group, as the first dimension) and Grp_Prd (product group, as the second).

1 Expression: Market share: sum(Sales) / sum(total <Grp_Geo> Sales).

And in the tab 'Dimension Limits', I show only the biggest vTop+1 products: (as i show 'others')

Untitled.png

And i have a slider to adjust the value of vTop:

Untitled.png

This chart mostly works pretty well as below shows:

Untitled1.png

but sometimes i changed the value of vTop, this chart said 'Allocated Memory Exceeded':

Untitled2.png

This happened mostly when i set the Grp_Geo to a more detailed level. The fact table contains 622M rows and 50 fields.

I want to know why this happened and how to avoid this?

Thanks in advance.


1 Solution

Accepted Solutions
amit_saini
Master III
Master III

Duo,

Normally, this happens when you are trying to show too many values on your table or when computing the table takes too much memory, depending on the RAM that is available on your computer / server.

This is not intuitively linked to the changes you are making to the table. If you keep it this way, the risk is that the message will appear "randomly" when the load is too high, looking like it's a bug.

Reloading, re-opening the app and stuff like this will just be a temporary fix but will not solve the root of the problem.

You have to try to reduce the amount of data you want to include in the table (think about the user experience) or use a machine with more RAM if you cannot shrink it further.

Thanks,

AS

View solution in original post

6 Replies
danieloberbilli
Specialist II
Specialist II

Please have a look at this thread and word-doc: Show Top Performers

http://community.qlik.com/docs/DOC-5187       

The Dimension Limit is very performance heavy - try to limit the results within the expressions like with the recommended rank() functions

Not applicable
Author

Thank you very much, Daniel. In this case do you know what is the right expression using rank() that if i want to achieve the same chart as i have posted? Thank you.

amit_saini
Master III
Master III

Duo,

Normally, this happens when you are trying to show too many values on your table or when computing the table takes too much memory, depending on the RAM that is available on your computer / server.

This is not intuitively linked to the changes you are making to the table. If you keep it this way, the risk is that the message will appear "randomly" when the load is too high, looking like it's a bug.

Reloading, re-opening the app and stuff like this will just be a temporary fix but will not solve the root of the problem.

You have to try to reduce the amount of data you want to include in the table (think about the user experience) or use a machine with more RAM if you cannot shrink it further.

Thanks,

AS

amit_saini
Master III
Master III

Duo ,

For Rank function please see the attachments.

Thanks,

AS

Not applicable
Author

Thank you very much for your examples and explaination. I have fully understood the reason why the memory exceeded. I have thought about soluton to resolve this. Thank you very much again.


amit_saini
Master III
Master III

Cheers