Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
Hi
You can restrict the data from DB in the DB query itself or in Qlikview script using the Where Clause.
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