topic Find a specific text in a field in QlikView

Find a specific text in a field

Fri, 02 Mar 2012 15:41:15 GMT

Hello everyone,

I have to put a condition on a field:

the sql looks like this:

upper(pp.name) like '%PARCHETUL%' OR upper(pp.name) like '%PREFECT%' OR......

how can this conditions be implemented into a expression from a table.

The only functions I have found are: left() right() mid()...but this can't be used...

Help me please in this small problem.

Thank you in advance!

Silviu

Find a specific text in a field

Fri, 02 Mar 2012 17:35:56 GMT

I think the function you are looking for is wildmatch. It would work something like:

Expression Definition:

= IF(wildmatch(name field, '*PARCHETUL*','*PREFECT*',etc...),1,0) or whatever you want to display for the expression when you find a match or not rather than the 1 and 0.

Wildmatch returns true for each string found. The * is the equivalent of the % in sql.

Find a specific text in a field

Fri, 02 Mar 2012 17:40:51 GMT

thank you!

I will try to use wildmatch. Hope it works.

good day,

Silviu