Create a filter with values to check if exist in a column

[mmg1984]

Hello,

I have the following problem, I'll try to explain it with easy data, I have 2 tables:

Filtering table:

White 

Black 

Blue 

Data Table:

Black;White 

White 

Blue;White 

Black 

What I want to do is to put Filtering table in a filter and Data Table in a table so I can select one colour in the filtering and that will filter the Data Table by any row that contains that colour, example if I select Black the result would be:

Data table:

Black;White 

Black 

Any idea how can I do it?

Thanks in advance 

[G3S]

this might help:

https://community.qlik.com/t5/QlikView-App-Dev/wild-card-characters-and-in-qlik-sense/td-p/135608

[vinieme12]

As below, use field FilterColors to filter DataTable;

DataTable:

Load *,recno() as ID inline [

Colors

Black;White 

White 

Blue;White 

Black ];

FilterValues:

Load ID, Subfield(Colors) as FilterColors

Resident DataTable;