Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

danny4202001
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 ?

Thanks in advance

1 Solution

Accepted Solutions

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={'123', '456', '789', '987', '654', '321'}>}ABC), ABC)

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

2 Replies

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={'123', '456', '789', '987', '654', '321'}>}ABC), ABC)

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

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

Community Browser