Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

pauldamen
Contributor II

Search text part in if statement

    Hi,

I have a whole list of website links which I want to aggregate in an other listbox. For example if have all kinds of links that contain the word control, using a if statement I want to put this in a listbox (I have 8 groups I want to put the words in), so my if statement looks like this:

if(cm_parentid = '*control*', 'Control', if(cm_parentid = '*performancemanagement*', 'Performance Management', etc. etc.

The problem is that it doesn't understand the * as a fuzzy search. How can I make this listbox using parts of the word?

Thanks!

Paul

1 Solution

Accepted Solutions
Not applicable

Re: Search text part in if statement

Hi Paul,

You can use the wildmatch function like this:

if(WildMatch(cm_parentid, '*control*'), 'Control', if(WildMatch(cm_parentid, '*performancemanagement*'), 'Performance Management'))

Hope it helps.

1 Reply
Not applicable

Re: Search text part in if statement

Hi Paul,

You can use the wildmatch function like this:

if(WildMatch(cm_parentid, '*control*'), 'Control', if(WildMatch(cm_parentid, '*performancemanagement*'), 'Performance Management'))

Hope it helps.

Community Browser