Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
toddprete
New Contributor II

Wildcard Mapping in QlikSense

Does anyone have an example of how I can do Wildcard mapping in Qliksense scripting.

Basically I have a list of names in a mapping table.   I want to search all my customer names from the customer table to see if the name contains any of words in the mapping table.

Mapping Table:

Osama

Guns

Weapons

Church

OJ Simpson

I want to know if the Customer Name contains any of the words in the mapping table.  So if the Customer Name is 'We sell Guns' then that is a hit.

Thanks  Todd

1 Reply
MVP & Luminary
MVP & Luminary

Re: Wildcard Mapping in QlikSense

You could do it with mapsubstring() similar to this one: Re: Passing parameter strings that contain special characters.

- Marcus