Out of object memory error.

[#1]

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.

[jonas_rezende]

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]

Hi

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

[vishsaggi]

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