topic Hide all line condition in QlikView

Hide all line condition

Mon, 16 Apr 2012 14:42:49 GMT

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

like: column = 'Prata' hide all line

CELAMBARASAN — Mon, 16 Apr 2012 14:50:02 GMT

Hi,

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

Celambarasan

jonathandienst — Mon, 16 Apr 2012 14:52:58 GMT

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

Regards

Jonathan

Mon, 16 Apr 2012 14:55:09 GMT

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

jagannalla — Mon, 16 Apr 2012 15:08:46 GMT

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 — Mon, 16 Apr 2012 15:15:10 GMT

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