topic Out of object memory error. in QlikView

Out of object memory error.

Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone.

I am having a trouble making a table box. When I tried to creat it, it shows me 'out of object memory'. I guess my information from database is really huge. Could you guys tell me how I can reduce information from database? For example, if information is from year 2005, I only want to fetch info from database from year 2015 so that I do not use so much memory for useless part.

Thank you in advance.

Best regards,

Hojun Seo.

Re: Out of object memory error.

jonas_rezende — Tue, 03 Jan 2017 17:06:10 GMT

Hi, Hojun Seon.

Include in your script include a clause where for the year. Ex.:

TableA:

LOAD

Year

from

[datasource]

where

year = 2015;

I hope this helps!

Re: Out of object memory error.

krishnacbe — Tue, 03 Jan 2017 17:08:27 GMT

You can restrict the data from DB in the DB query itself or in Qlikview script using the Where Clause.

Re: Out of object memory error.

vishsaggi — Tue, 03 Jan 2017 17:16:07 GMT

As suggested above, try using a where clause in Load or SQL query like

SQL

Select col1, col2, Date

FROM yourtablename

WHERE Year(Cast(PERIODDATE AS Date)) >= 2015