topic Re: Matching text to concatenated text in QlikView

Matching text to concatenated text

Mon, 23 Jun 2014 14:01:23 GMT

I have a variable Doctor1 that contains the following text : DR. X,DR. Y. I am trying to compare the variable to a table field using the below but it isn't working:

=if(mixmatch(ATTENDING_NAME , (Doctor1)),2)

Can anybody assist please?

Re: Matching text to concatenated text

alexandros17 — Mon, 23 Jun 2014 14:07:49 GMT

Use this syntax:

=if(mixmatch(ATTENDING_NAME , $(Doctor1)),2)

Let me know

Re: Matching text to concatenated text

Mon, 23 Jun 2014 19:59:49 GMT

No result

Re: Matching text to concatenated text

maxgro — Mon, 23 Jun 2014 20:17:30 GMT

the variable should be

'DR. X','DR. Y.'

Re: Matching text to concatenated text

Tue, 24 Jun 2014 05:11:57 GMT

The variable can hold different doctor names depending on the user selection.

Re: Matching text to concatenated text

tresB — Tue, 24 Jun 2014 05:19:56 GMT

I guess you need:

=if(mixmatch('$(Doctor1)' ,ATTENDING_NAME ),2)

Re: Matching text to concatenated text

jagan — Tue, 24 Jun 2014 05:34:24 GMT

Hi,

Try like this, you need to give single quotes for variable, since it is a string.

=if(mixmatch(ATTENDING_NAME , '$(Doctor1)'),2)

Regards,

Jagan.

Re: Matching text to concatenated text

Tue, 24 Jun 2014 05:39:52 GMT

I entered the following expression but still getting no values:

if(mixmatch('$(Doctor1)' ,ATTENDING_NAME ),2)

Re: Matching text to concatenated text

jagan — Tue, 24 Jun 2014 05:45:49 GMT

Hi Nassar,

Try like this

=if(Index(Upper(ATTENDING_NAME ) , Upper(Doctor1)),2)

Regards,

Jagan.

Re: Matching text to concatenated text

tresB — Tue, 24 Jun 2014 05:48:18 GMT

Mixmatch() is exact match(case insensitive) function. For your case, you have to use wildmatch() or substringcount() or index(). Try like:

if(Index('$(Doctor1)' ,ATTENDING_NAME ),2)

Note: to take care of case insensitivity, use for both strings upper()/lower().

Re: Matching text to concatenated text

phaneendra_kunc — Tue, 24 Jun 2014 05:53:26 GMT

it doesn't work...with your current expression.

as you can see you don't have single quotes per name.

Usually it has to be like ------------> 'DR.X','DR.Y'

Replace your Doctor1 Variable with this...Not sure how you are calculating those names..

=chr(39)&Concat(NAME,chr(39)&','&chr(39))&chr(39)

And use $(Doctor1) in your mixmatch expression with out single quotes..

Regards

Phani

Re: Matching text to concatenated text

Tue, 24 Jun 2014 06:02:10 GMT

Thanks a lot.

The above worked fine