Need to display a list of names based on their matching a string from an Input Box.

[rmadursk]

If I have a list like this. 2 Columns:

Place Name

1   First, Person

2 Second, Person

3 Third, Person

and i want to use a variable, let's call it vSearchBox, to decide which rows to display in a table. 

If I put first in the input box I only want to see 1 row of data.

If I put ird in the input box I only want to see 1 row of data.

If I put erson in the input box I want to see 3 rows of data.

If the input box is empty I want to see all 3 rows of data.

What would my syntax be?

Should I create a set expression?  I've tried using WildMatch, Like, Only and various if statements to get what I want but I'm stumped and can't find a relevant example in the forums.

[Anil_Babu_Samineni · Accepted solution]

I suspect this is in Qlik view since you mentioned Input box.

Anyway, Something like this?

When you type In Input Box and enter?

QVW attached for ref.

Expression Used for Place: =If(WildMatch(Place, '*' & '$(Variable1)' & '*'), Place)

[rmadursk]

It is in Qlik Sense. I should have been more specific.  It is a Variable Input Box from the Dashboard bundle.

Also, Place is an integer and all 3 people have the same last name.

I did not try using the & for the comparison string.  That seems to do the trick.

Many thanks.