https://community.qlik.com/t5/QlikView/protect-out-off-memory/m-p/1764432#M591217 <P>Maybe optimizing the UI and the datamodel may help - things like avoiding if-loops, aggr-constructs, interrecord-functions and ensuring that all relevant fields come from a single table ...</P><P>If this is really not an option you may add a calculation-condition on your objects, something like:</P><P>count(distinct dim1&amp;dim2&amp;dim3)&lt;10000</P><P>- Marcus</P> Wed, 25 Nov 2020 15:20:06 GMT marcus_sommer 2020-11-25T15:20:06Z https://community.qlik.com/t5/QlikView/protect-out-off-memory/m-p/1764411#M591216 <P>tabel&nbsp; loaded at start is large(qvd type)&nbsp; , normaly user&nbsp; need to show only a part of data, like&nbsp; 1 year, however it happens he clicks on button clear all choices he could make,&nbsp; then qlik starts reading , dislaying all years, and will hang in memort error</P><P>not responding anymore</P><P>how sowe way to make sure when he clears all&nbsp; somehow keep at minumum 1 year or other item filled with a fixed value like this year only</P> Sat, 16 Nov 2024 17:46:38 GMT https://community.qlik.com/t5/QlikView/protect-out-off-memory/m-p/1764411#M591216 JACKNIEKERK 2024-11-16T17:46:38Z https://community.qlik.com/t5/QlikView/protect-out-off-memory/m-p/1764432#M591217 <P>Maybe optimizing the UI and the datamodel may help - things like avoiding if-loops, aggr-constructs, interrecord-functions and ensuring that all relevant fields come from a single table ...</P><P>If this is really not an option you may add a calculation-condition on your objects, something like:</P><P>count(distinct dim1&amp;dim2&amp;dim3)&lt;10000</P><P>- Marcus</P> Wed, 25 Nov 2020 15:20:06 GMT https://community.qlik.com/t5/QlikView/protect-out-off-memory/m-p/1764432#M591217 marcus_sommer 2020-11-25T15:20:06Z https://community.qlik.com/t5/QlikView/protect-out-off-memory/m-p/1764954#M591218 <P>indeed we should optimize</P> Fri, 27 Nov 2020 13:55:49 GMT https://community.qlik.com/t5/QlikView/protect-out-off-memory/m-p/1764954#M591218 JACKNIEKERK 2020-11-27T13:55:49Z