topic Re: Hide a row in straight table in QlikView

Hide a row in straight table

dseelam — Thu, 23 Jan 2014 19:05:03 GMT

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

Re: Hide a row in straight table

Nicole-Smith — Thu, 23 Jan 2014 19:09:05 GMT

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)

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

Anonymous — Thu, 23 Jan 2014 19:09:50 GMT

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