topic Re: match - function in QlikView

match - function

Thu, 27 Feb 2014 08:35:44 GMT

Hello together,

i have a table with ColA => apple, cycle and a table with ColB => cycle

is it possible with the wildmatch or another function, to show, that the value cycle in ColB is part of ColA?

match(ColB,ColA) returns 0. I want that the function returns a 1.

Thanks a lot!

Best regards,

Aylin

Re: match - function

maxgro — Thu, 27 Feb 2014 09:06:03 GMT

try with

=wildmatch(ColA, '*' & ColB & '*')

but if if you have more values in ColA and ColB

it only works when you select 1 value in each columns

LOAD * INLINE [

ColA

"apple, cycle"

"cycle, fruit"

];

LOAD * INLINE [

ColB

cycle

square

];

Re: match - function

Thu, 27 Feb 2014 09:08:38 GMT

See

exists()

fieldIndex()

Fabrice

Re: match - function

er_mohit — Thu, 27 Feb 2014 09:17:29 GMT

Try this in text box

if(len(trim(mid(ColA,Index(ColA,',')+1)))=len(ColB),1,0)

Re: match - function

CELAMBARASAN — Thu, 27 Feb 2014 09:22:22 GMT

Hi,

Sometimes the textobject expression varies from chart expression, script expression. Could you please describe about the scenario or what/ where the expression is to be applied?

Re: match - function

Thu, 27 Feb 2014 09:24:40 GMT

Thanks a lot for your helps.

I resolved it with the index function! =If(Index(ColA, ColB) > 0, 'TRUE', 'FALSE')

Re: match - function

CELAMBARASAN — Thu, 27 Feb 2014 09:29:21 GMT

FYI: Index will be case sensitive comparison. if thats what you want very well you can go with that

=If(Index(ColA, ColB), 'TRUE', 'FALSE') //this is enough

Re: match - function

simondachstr — Thu, 27 Feb 2014 09:30:58 GMT

=Index(ColA, ColB) // this is enough (for conditional shows e.g.)