topic Hiding a Row in a TableBox in QlikView

Hiding a Row in a TableBox

Wed, 17 Mar 2010 09:16:54 GMT

Hi All,

Is it possible to hide a row based upon a condition in a tablebox? Basically I want to exclude rows where a certain columns value is null.

Thanks

Hiding a Row in a TableBox

Anonymous — Wed, 17 Mar 2010 09:29:52 GMT

A table box cannot contain conditions / expressions ...

If you want something by hiding rows etc it can be better done in a chart (pivot or straight).

In the expression you could add something which makes the value empty when it doesn't need to be shown.

When all expression columns have a 'null' value the row is not displayed.

hope this helps you out.

Anita

Hiding a Row in a TableBox

michael_anthony — Wed, 17 Mar 2010 10:19:30 GMT

Try the Presentation Tab in the properties of the table box. Select the field that has the Nulls to be excluded and check the box that allows you to Omit Rows with Null Values.

That works as a neat trick to control rows in table boxes. I often create a 1 / Null field in script to flag something (eg. Overdue item) and then use Table Box with Null excluded on that field.