Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
adley51788
New Contributor III

Input box string to select in field action with spaces

Hi all,

I am trying to have a user input a string to search a field for relevant information.

So far, I was able to remove the spaces and create the syntax for the action.

For example:

User searches for:

Test two

Syntax:

='(*'&replace(vInputNew,' ','*|*')&'*)'

Output in text box:

(*Test*|*two*)

What I would like to do next:

Take the user inputs and select in field action for the relevant words in a description field.

Thanks.

Tags (2)