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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
mlarruda
Creator II
Creator II

How can I set a dynamic condition to filter registers in a table?

Hello, I have a table with the dimensions NAME and MONTH and several expressions, one of which is SUM(CASES). Since there are thousands of names and dozens of months, the complete table is not displayed on the screen (QlikView returns an error message like “Insufficient memory”).

So I created a variable vMinCases and I want the table to show only those NAMES whose overall SUM(CASES) (over all months) is greater than the value entered for vMinCases. How can I do this?

2 Replies
rubenmarin1

Hi, initially a table can show hundreds of thousands or even millions of rows, but if it has some complex calcualtion or dimensions splitted by different tables in a complex or non-optimized model, it will need more memory to merge all the information.

That said, you can limit the table just using the dimension limitations by exact value, like:

rubenmarin_0-1734192366357.png

Another option might be using set analysis, like: {<NAME={"=Sum(CASES)>$(vMinValue)"}, but this should be set in each expression.

There is also the option to filter in Name dimension using a calculated dimension as:

Aggr(If(Sum(CASES)>$(vMinValue),NAME),NAME)

 

marcus_sommer

Don't play further with this table until the data-model isn't suitable prepared. Officially recommended is a star-scheme with one fact-table and n dimension-tables.