Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

Highlighted
SMAKI
New Contributor

Hide and show column

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%'   
7 Replies
Somasundaram
Contributor III

Re: Hide and show column

hi,

 

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

 


-Somasundaram
shiveshsingh
Honored Contributor

Re: Hide and show column

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

MVP
MVP

Re: Hide and show column

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 ....
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
SMAKI
New Contributor

Re: Hide and show column

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
New Contributor

Re: Hide and show column

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
New Contributor

Re: Hide and show column

Hi Please reply..
SMAKI
New Contributor

Re: Hide and show column

Pls reply
Community Browser