Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
GHasan
Contributor III
Contributor III

Show different columns (table) when different filters are selected

Hi, 

I have a filter with X Y Z and a table that reacts to the selection. Is there a way to create a table that will show only columns  A,B,C when filter X is selected and only columns P,Q,R when filter Y is selected?

Thanks is Advance. 

Labels (1)
4 Replies
anat
Master
Master

can you try using conditional show

 

squreshi
Contributor II
Contributor II

Hi GHasan,

Need to use "Enable Conditional" feature.

Use below expression in A,B,C Columns to show them when X is selected in filter:

If(GetFieldSelections(Filter)=X,1,0)   

Use same approach to show P,Q,R columns When Y is selected .

Hope, this will answer your question.

Please mark it correct, if you find it useful.

Cheers !
Squeshi

GHasan
Contributor III
Contributor III
Author

Yes I used it, and it worked. 

Thank you

GHasan
Contributor III
Contributor III
Author

Hi Squreshi, 

I used the following and it worked:

GetSelectedCount(Selection)> =1 AND Concat(Selection, ' , ') Like  '*X*'


Thanks