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: 
smilingjohn
Specialist
Specialist

Hide and show column

Hi All, 

I have a inline table "Category"   which I am considering as a filter pane. 

If I select Category (Cosmatic) then i want to hide my 3 columns (football,cricket and movie) and show only one column BeautyProduct in my pivot table . 

and when i dont select Category then BeautyProduct should be hidden and  3 column  (football,cricket and movie) should be displayed. 

How can I cahive this ?

Thanks in Advance

 

1 Solution

Accepted Solutions
MayilVahanan

Hi @smilingjohn 

Try like below

=GetselectedCount(Category)= 0 for 3 columns.

MayilVahanan_1-1614239616130.png

For BeautyProduct , provide the condition like below

=Category='Cosmatic'

Hope it helps

 

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

1 Reply
MayilVahanan

Hi @smilingjohn 

Try like below

=GetselectedCount(Category)= 0 for 3 columns.

MayilVahanan_1-1614239616130.png

For BeautyProduct , provide the condition like below

=Category='Cosmatic'

Hope it helps

 

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.