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

meme — Thu, 04 May 2023 06:36:57 GMT

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.

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

meme — Thu, 04 May 2023 08:09:50 GMT

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)

topic Re: How to create a filter for a field that contains multiple values. in QlikView

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

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