topic Re: Categorizing List Box Data Advanced Fuzzy Search in QlikView

Categorizing List Box Data Advanced Fuzzy Search

Sun, 21 Oct 2012 07:22:19 GMT

I pulled data from Salesforce.com and the table in QlikView contains leadID and SearchPhrase as fields.

I am looking for a way to label SearchPhrase data as "branded" if it contains "phd" or "esxpress", and "nonbranded" if does not contain such words. So then I can make a new list box called "Label" and have "branded" and "nonbranded" as the choices in the list box so i could easily see which leads were branded vs. non-branded. I know I can do fuzzy searches for "phd" and "esxpress" on the SearchPhrase list box that I already have, but being able to create the "Label" list box would make analysis for end users much easier and better . Anyone know how I can accomplish this?

Re: Categorizing List Box Data Advanced Fuzzy Search

Gysbert_Wassenaar — Sun, 21 Oct 2012 09:25:32 GMT

You can use Rob Wunderlichs QV Cookbook (http://robwunderlich.com/downloads). It has an example of mapping with wildcards. With this technique you can create a new field for your label. You can then add a new listbox for the new label field.

Re: Categorizing List Box Data Advanced Fuzzy Search

Mon, 22 Oct 2012 13:03:45 GMT

Thanks for your prompt reply. The link you shared appears to be filled with a lot of useful info. I just downloaded the QV example titled "Mapping with Wildcards" and I will follow the logic. Thanks.