Filter population based on field selection

[#1]

I have a field containing the following information:

Member                         Years

1                                     2017, 2016, 2015

2                                     2017, 2015

3                                     2016, 2015

When selecting a filter, I want to show the members that were in 2017 AND the members that were also in 2015.  So, in this case, I want to show Member 1 and 2.

How can I do this with Qlikview. Is there a way I can use my filter to strip out information from my Years Field?

[Anil_Babu_Samineni]

May be this?

Load Member, SubField(Years) as Years Inline [

Member        ,                 Years

1                   ,                  2017, 2016, 2015

2                    ,                 2017, 2015

3                     ,                2016, 2015

] where Match(SubField(Years),'2015','2017');