topic Re: How to sort Out of Object Memory problem in QlikView

How to sort Out of Object Memory problem

Mon, 18 Nov 2013 10:49:46 GMT

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.

Re: How to sort Out of Object Memory problem

bbi_mba_76 — Mon, 18 Nov 2013 10:53:26 GMT

Hi,

how many columns/data there are?

There are calculated dimensions?

If you applied some filters there is still the error?

Re: How to sort Out of Object Memory problem

Mon, 18 Nov 2013 10:55:00 GMT

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.

Re: How to sort Out of Object Memory problem

datanibbler — Mon, 18 Nov 2013 10:56:32 GMT

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

Re: How to sort Out of Object Memory problem

Mon, 18 Nov 2013 11:01:58 GMT

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.

Re: How to sort Out of Object Memory problem

datanibbler — Mon, 18 Nov 2013 11:07:51 GMT

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.

Re: How to sort Out of Object Memory problem

Mon, 18 Nov 2013 11:13:29 GMT

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!

Re: How to sort Out of Object Memory problem

Clever_Anjos — Mon, 18 Nov 2013 11:14:01 GMT

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

Re: How to sort Out of Object Memory problem

Mon, 18 Nov 2013 11:16:58 GMT

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.

Re: How to sort Out of Object Memory problem

Mon, 18 Nov 2013 11:20:43 GMT

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 .

Re: How to sort Out of Object Memory problem

DavidFoster1 — Mon, 18 Nov 2013 11:37:05 GMT

This is usually an issue if there are too many rows in the object. If that is the case then you need to either reduce the granularity of the data you are shwing (e.g. showing product group instead of individual products). Alternatively use a calculation condition to stop the object rendering until sufficient selections have been made to make the number of rows manageable.

Re: How to sort Out of Object Memory problem

Mon, 18 Nov 2013 11:48:20 GMT

Thanks and I can able to get it now.