topic Re: Match a field with Concatenated values in QlikView

Match a field with Concatenated values

DanaL — Wed, 02 Jun 2021 06:04:56 GMT

Hi,

I'm trying to apply the Match function.

These are the fields & Values:

TmpOrder_Type :SLS

ConcatExcludeOrderTypes: 'SLS','SRV'

The expression Match(TmpOrder_Type, ConcatExcludeOrderTypes) displays 0.

Can someone help me figure out why?

Thanks!

Re: Match a field with Concatenated values

MayilVahanan — Wed, 02 Jun 2021 07:51:47 GMT

Hi @DanaL

Try with Index or Substringcount

=SubStringCount(ConcatExcludeOrderTypes,TmpOrder_Type)

returns 1

Re: Match a field with Concatenated values

DanaL — Wed, 02 Jun 2021 08:24:51 GMT

That works..

Thank you!

Any idea why the Match doesn't?

Re: Match a field with Concatenated values

MayilVahanan — Wed, 02 Jun 2021 08:51:37 GMT

HI @DanaL

Match function returns true when its exactly both values are same.

For ex:

match('Apple', 'Apple') returns 1

Re: Match a field with Concatenated values

DanaL — Wed, 02 Jun 2021 10:04:48 GMT

Hi,

Please notice the example from Help

Re: Match a field with Concatenated values

MayilVahanan — Wed, 02 Jun 2021 10:22:07 GMT

Hi @DanaL

FYI,

Your ConcatExcludeOrderTypes field has single values with combined string i.e. 'SLS','SRV'.

In Help, Jan, Feb, Mar are 3 individual values.. its not a single string.

Re: Match a field with Concatenated values

DanaL — Wed, 02 Jun 2021 11:14:52 GMT

Hi,

What's the difference between the values?

In both cases they look the same, no? 'SLS','SRV' vs 'Jan','Feb'

Re: Match a field with Concatenated values

MayilVahanan — Thu, 03 Jun 2021 00:26:13 GMT

In List box, you can see the values like below for your ConcatExcludeOrderTypes

SLS,SRV

Month Field likes

Jan

Feb

Match function will return true when its exactly match, else return false.

Suppose, if TmpOrder_Type field also has single value like SLS,SRV, then it return true.

Re: Match a field with Concatenated values

DanaL — Thu, 03 Jun 2021 04:31:08 GMT

Now I get it 🙂

Thanks for clarifying!