Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to sort Out of Object Memory problem


Hi,

I have a staright table and when I am adding fields it is showing data and after completingnwhen I am clicking OK it is showing 'Out of Object Memory'.

Could anyone help me how to sort this problem

In straight table there are onlt columns and I haven't used any expression like sum/count/distinct and so on.

Thanks.

1 Solution

Accepted Solutions
Not applicable
Author

If you don't have any calculations/expressions/If conditions and you are using direct columns then you can try using table box instead of a straight table as suggested by Clever Anjos .


Edit : You can try having some selection in EmployeeId field, just have few EmployeeIds selected which will reduce the amount of data.

If this is successful then you can try reduction of data based on some field .

View solution in original post

11 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

how many columns/data there are?

There are calculated dimensions?

If you applied some filters there is still the error?

Not applicable
Author

Hi,

There are 7 columns and there is no need to use any calculated dimensions because I need to take all data as it is which is in columns. Please help me in this case hwo to sort this.

datanibbler
Champion
Champion

Hi Amelia

I had the same problem once. In my instance, it was this:

=> I had typed all the fields I wanted to see as dimensions

=> Behaviour was the same as yours,

   - it took ages loading (only the diagram, the script was ok)

   - and it often displayed "Out of memory",

=> The solution was, I built a key to see just how many dimensions I really needed to uniquely identify an item (only 3 or 4) and I just entered the remainder as formulas.

HTH

Best regards,

DataNibbler

Not applicable
Author

Hi,

Could you explain a bit more how you solved this problem please as I haven't getting any idea about uniquely identify an item means.

datanibbler
Champion
Champion

Hi,

provided you get unique data (no duplicates) from your data_source:

- just use RowNo() for a line_ID

- build a diagram (or use the one you have) and add an expression >> COUNT(line_ID) <<

=> Test out how many dimensions you need until you have only the value 1 in that field.

Not applicable
Author

Hi Amelia,

This happens usually because of insufficient viirtual memory.

Please refer to http://community.qlik.com/message/343784

You can try the options mentioned by Mohit sharma in the above discussion.

Hope this helps!


Clever_Anjos
Employee
Employee

If you don´t need calculations, don´t use straighttable, use a Table Box object

Not applicable
Author

Thanks and I no need to use any expressions or any IF conditions. I need to use just columns. Please help hwo to get this only with columns.

Actually I have one column with huge data

TransactionID

for one employeeID there are more than 50 tranactionIDs and this craeting the problem

Please help how to sort this and I used EmplyeeID as dimension and remaining columns as expressions.

Not applicable
Author

If you don't have any calculations/expressions/If conditions and you are using direct columns then you can try using table box instead of a straight table as suggested by Clever Anjos .


Edit : You can try having some selection in EmployeeId field, just have few EmployeeIds selected which will reduce the amount of data.

If this is successful then you can try reduction of data based on some field .