Hide and show column

[SMAKI]

Hi

Hi  I'm very new to qlikview.  could you please help me to provide the best way to learn how to  1. hide 3 columns based on another column value

eg: I want to hide column1, column2, column3 based on column4 where the column4 value like 'ABC%' and show if the  column4 value like 'XYZ%'   

[Somasundaram]

hi,

Use  expressions-> conditional provide the condition, based on the condition it will show /hide the column.

[shiveshsingh]

You can put conditional expression to cater this requirement in qlikview.

[jonathandienst]

That's a little confused. You want to hide the column based on a single value in another column? Which value - from the first row, last row ....

[SMAKI]

Thanks. How does the condition looks like?

sorry i'm very new and i don't even know the syntax of qlikview

eg:
something like that?

if( column4  like 'ABC%', 'hide column1 + column2 + column3', 'show column1 + column2 + column3' )

[SMAKI]

Actually it is something like batch number i capture in a column. So if the batchnumber starts with 'ABC%' for any row, i want to show another 3 columns, if not i want to hide those columns.. 

[SMAKI]

Hi Please reply..

[SMAKI]

Pls reply