How to sort Out of Object Memory problem

[#1]

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.

[bbi_mba_76]

Hi,

how many columns/data there are?

There are calculated dimensions?

If you applied some filters there is still the error?

[#3]

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]

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

[#5]

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]

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.

[#7]

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]

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

[#9]

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.

[#10 · Accepted solution]

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 .