Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

display fields according to filter selections

Hi All,

I have a table  and I am using a the below condition to display the fields according to the filter selection . 


=if(GetFieldSelections([Game Type])='cricket',Cricket_team,wrestling_team)


My need is like if I select Game type as cricket then it whould display the field Cricket_team, and if I select Wrestling

then it should hide cricket_team and display only the selected game type ,

If i select both then both should be selected how do i do this ? 

I can make selection of one team at a time , 




1 Reply


Add both columns to your table and in the "Show Column if" expression use:

For Cricket_team:

=if(GetSelectedCount([Game Type]) >= 1 and match('cricket',$(=concat(chr(39)&[Game Type]&chr(39),',')))>=1,1,0)

For wrestling_team:

=if(GetSelectedCount([Game Type]) >= 1 and match('wrestling',$(=concat(chr(39)&[Game Type]&chr(39),',')))>=1,1,0)