Search text part in if statement

pauldamen — Fri, 28 Dec 2012 09:28:58 GMT

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

Re: Search text part in if statement

Fri, 28 Dec 2012 09:47:04 GMT

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.

topic Search text part in if statement in QlikView

Search text part in if statement

Re: Search text part in if statement