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

[mlarruda]

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?

[rubenmarin]

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:

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.