topic Select in Field & searching a phrase in QlikView

Select in Field & searching a phrase

Thu, 16 Oct 2014 15:44:32 GMT

Hi all -

I have a button with an action to Select in Field. I cannot figure out how to define my search substring to be a specific combination of two words. I would like to select any values within my specified field that contain the phrase "accounting department" - in that order, and only in with both words (not 'accounting', 'department', or 'department accounting'). What am I doing wrong here? Thanks!

Re: Select in Field & searching a phrase

tiagopost — Thu, 16 Oct 2014 15:53:05 GMT

did you try this *accounting department* ?

Re: Select in Field & searching a phrase

Thu, 16 Oct 2014 15:59:15 GMT

Tiago - this worked beautifully. Thank you very much! Can you tell my why the second * makes the difference? I tried *accounting department before (without the second *) and it wasn't working correctly.

Re: Select in Field & searching a phrase

tiagopost — Thu, 16 Oct 2014 16:05:59 GMT

the first "*" mean anything before

and the seconde "*" mean anything after the key word

if you try just with first *
you would get "one acc depart" in my example, but not the "acc depart test".