# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Contributor

## Hide a row in straight table

Hello Guys,

I have a straight table with 15 dimensions and 3 expressions  and many rows for each dimensions and expression in that I have to hide particular rows of one dimension called ABC with particular values like 123, 456, 789, 987, 654, 321

how can I hide a column ABC with only particular values ?

1 Solution

Accepted Solutions
MVP

## Re: Hide a row in straight table

For your ABC dimension, create a calculated dimension instead and suppress values when null.  Calculated dimension should be something like:

 if(not match(ABC, '123', '456', '789', '987', '654', '321'), ABC)

or

 aggr(only({\$-}ABC), ABC)

Or you can use this same set analysis in your expression(s): {\$-<ABC={'123', '456', '789', '987', '654', '321'}>}

2 Replies
MVP

## Re: Hide a row in straight table

For your ABC dimension, create a calculated dimension instead and suppress values when null.  Calculated dimension should be something like:

 if(not match(ABC, '123', '456', '789', '987', '654', '321'), ABC)

or

 aggr(only({\$-}ABC), ABC)

Or you can use this same set analysis in your expression(s): {\$-<ABC={'123', '456', '789', '987', '654', '321'}>}

MVP

## Re: Hide a row in straight table

Dinesh

Assuming when you mean hide the row and not the column, then either use a calculated dimension or set analysis in the expressions.

Best Regards,     Bill