topic Re: Keyword Search in QlikView

Keyword Search

Anonymous — Fri, 20 Nov 2015 08:56:43 GMT

Hi,

I have a word list which I need to search in the item description field. E.g. words like Gold, Silver, Copper, etc. I tried using the wildmatch function in the script "where WildMatch ([Item Description], '*Gold*', '*Silver*, '*Copper*' and it worked fine.

The problem I am facing is that I need to show a column alongside the item description stating which word was found in which field, e.g.the final output should look something like below along with other fields in the file

Keywords Item Description

Gold Bought Gold worht USD2000

Silver Silver Ornamanet purchase

Copper Copper plates bought worth 1000 USD

Please advise

Thanks

Sunny

Re: Keyword Search

marcus_sommer — Fri, 20 Nov 2015 12:36:44 GMT

You could use pick(match()) for this:

pick(WildMatch ([Item Description], '*Gold*', '*Silver*, '*Copper*'), 'Gold', 'Silver', 'Copper')

But you will get only the value of the first matching.

- Marcus

Re: Keyword Search

swuehl — Fri, 20 Nov 2015 13:00:56 GMT

You can also have a look at

Keyword Mapping with Description