Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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 (1)
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