Hide all line condition

[#1]

It's possible hide all line when some column have a especifc value

like: column = 'Prata' hide all line

[CELAMBARASAN]

Hi,

     You mean hide all the rows in the table(need to display empty table)?

Celambarasan

[jonathandienst]

Hi

Or do you mean to hide the line if a column contains the value 'Prata'?

Regards

Jonathan

[#4]

hide the line if a column contains the value 'Prata'

[jagannalla]

Hello,

In straight table you can hide the columns.

GoTo -> Properties -> Presentaion -> choose the column which you want to hide -> check on Condition radio button

and paste this code =if(substringcount  (Concat(FieldName),'Prata')=1,False(),True()) in text box.

Hope it helps you.

[jonathandienst · Accepted solution]

Hi

To hide the row, let's for the sake of example, assume that the column to check is column 3:

For each expression (except column 3), change the original expression to:

If(Column(3) = 'Prata', 0, <original column expression here>)

And then make sure that suppress zeroes is enabled for the table. This should work on straight tables and pivot tables.

Regards

Jonathan