Find 1 text with 2 filters

[rawee]

I have the data below:

Field :a	Field 😛
x1	y1
z1	x1
y1	x2
x1	x1
x6	x7
y2	y2

Then I want to find the filter (field a) with x1 and Qlik return result below :

filter a : x1

result

Field :a	Field 😛
x1	y1
z1	x1
x1	x1

How to do? Pls help me.

[kaushiknsolanki]

Hi,

You can create a new field which is a concatenate of F1 and F2, like shown below.

Load F1, F2, F1 & ',' & F2 as F3 from xyz;

Now do the search in F3 for the value using wildcard search.

Regards,

Kaushik Solanki