Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
JACKNIEKERK
Creator
Creator

protect out off memory

tabel  loaded at start is large(qvd type)  , normaly user  need to show only a part of data, like  1 year, however it happens he clicks on button clear all choices he could make,  then qlik starts reading , dislaying all years, and will hang in memort error

not responding anymore

how sowe way to make sure when he clears all  somehow keep at minumum 1 year or other item filled with a fixed value like this year only

Labels (2)
1 Solution

Accepted Solutions
marcus_sommer

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 ...

If this is really not an option you may add a calculation-condition on your objects, something like:

count(distinct dim1&dim2&dim3)<10000

- Marcus

View solution in original post

2 Replies
marcus_sommer

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 ...

If this is really not an option you may add a calculation-condition on your objects, something like:

count(distinct dim1&dim2&dim3)<10000

- Marcus

JACKNIEKERK
Creator
Creator
Author

indeed we should optimize