how to limit the amount of data loaded into

[#1]

I need some urgent help on how to limit the amount of data loaded into QlikView? The large amunt of data causing Out of memory when try to load a report within QlikView.

Example, I would only want to limits 5 years of data load into QlikView with condition if one of the fields is check within the table then load all data. If the box is not check, then only display data for the last 5 years.

Is this possible? if so, how to accomplish this? Thanks in advance...

[jagan]

Hi,

Try like this

LOAD

*

FROM Table

WHERE (CheckBoxField = 'True') OR  (Date > YearStart(Today(), -4));

Note : Replace CheckBoxField = 'True' with you corresponding values.

Hope this helps you.

Regards,

Jagan.