Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
SMAKI
Contributor
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
Creator III
Creator III

hi,

 

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

 


-Somasundaram

If this resolves your Query please like and accept this as an answer.
shiveshsingh
Master
Master

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

jonathandienst
Partner - Champion III
Partner - Champion III

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

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

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

Hi Please reply..
SMAKI
Contributor
Contributor
Author

Pls reply