Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Out of object memory error.

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.

3 Replies
jonas_rezende
Specialist
Specialist

Hi, Hojun Seon.

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

TableA:

LOAD

A,

B,

C,

Year

from

[datasource]

where

year = 2015;

I hope this helps!

krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi

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

vishsaggi
Champion III
Champion III

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