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.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
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 , 

 

Thanks 

 

1 Reply
GaryGiles
Specialist
Specialist

@smilingjohn 

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)