Qlikview tips - hide specific rows in a table

There are totally 3 ways to hide specific rows based on dimensions columns and expression column, which are created in "Expression" tab) in Qlikview.


If you need to hide the rows based on the dimensions.
1.  You can use "Enable Conditional" in the Dimensions Tab, and then use expressions to select dimensions.

The tricky part is to hide the rows based on Expression columns, as Qlikview are not designed to do such job. BUT, we can do it by using expressions. Expression is such a beautiful  thing in Qlikview.

2. Use the "Dimension Limit" tab, where can show top N / N% of a table based on the first expression column.
Then we see the limitation, this is only available for the first expression column.

3. Use the expression in one of the expression column and variables. We use expression_column1as an example here. The expressions for all the columns are originally like below:
For example,
expression_column1 = expression1, and
expression_column2 = expression2
...
expression_columnN = expressionN

step1: You modify expression for  expression_column1 as below:
if ((var1 =1 and  expression1)<100)
     or (var2=1 and expression2)<1000)
     or (...),
     null(), expression1)
Here, you can use or/and to add all the conditions that you need to hide the rows. Pay attention, you can NOT  use "Label" in the Expression tab to refer to a specific expression column.

step2:And for other expression columns, you need to change their expression like below because a row can be hided when all the columns are null in that row.:
if(isNull()expression_column1, null(), expression2)
...
if(isNull()expression_column1, null(), expressionN)

As you need to generate other expression columns based on expression_column1 , that is why you can not use "Label" of other columns in step1.

In the way above, you can hide specific rows as you want. Method 1 is only for dimension columns, and 2 and 3 can be used based on both dimension columns and expression columns.

And you can download my qvw example here.