topic Re: Search for a string in a Field in QlikView

Search for a string in a Field

Tue, 26 Jun 2012 15:22:47 GMT

I'm trying to create a search function by searching through a Field with a specific word in a string however, I'm new to Qlickview & I'm not sure how to write the code for it.. The field I'm using is called "Description" and I'd like to search for all the entries that include the word "brake" "leak" or "oil filter".. etc.

Ideally, I'd like to have a listbox with key word selections: "brake" "leak" & "oil filter" in order to search through the Field "Description" so that I can sort through quality problems more efficiently. If it would be easier to create a variable or an expression in a pivot chart, please let me know. Any suggestions would be very much appreciated!!!

Re: Search for a string in a Field

Tue, 26 Jun 2012 15:27:57 GMT

Hi,

Please go to the help file by pressing F1,

search for String Functions & Conditional Functions,

which will help you for your case.

wildmatch, match, pick, mixmatch these are the some of examples.

Regards,

Prasath

Re: Search for a string in a Field

john_duffy — Tue, 26 Jun 2012 17:50:41 GMT

Hello.

I used the wildmatch and getfieldselections functions to display descriptions based on a key word selected in a list box. Note that the listbox has Always One Selected Value activated.

Not sure if this is exactly what you're looking for, but hopefully it helps.

John.

Re: Search for a string in a Field

rwunderlich — Tue, 26 Jun 2012 22:12:19 GMT

You may also want to look at this thread:

http://community.qlik.com/message/219564#219564

-Rob