How to create a filter for a field that contains multiple values.

[meme]

Hi everyone,

I am new in using QLIK and I wanted to check how can I achieve this.  I have a field that contains delimited value example

ID, Country -

1, Japan; Singapore, USA

2, Japan

3, USA

4, Thailand

I want to 2 things 1. on my filter pane display the unique country 2. for the filter to work such as for example if the user choose Japan it will display 1 and 2  and so on.

Appreciate your help and thanks in advance.

[meme · Accepted solution]

I think I was able to figure out what to do. I put this expression on the filter pane and it worked 

=subfield([Country],';',1)