topic LIKE operator in QlikView

LIKE operator

Tue, 17 Mar 2015 12:51:24 GMT

I am trying to use the LIKE operator in an IF() statement to match up two Field values:

=if(ImageName LIKE PhotoLookup&'*',ImageName,'')

However; on several occasions there is more than one value LIKE another.

PhotoLookup value: DA BLOFIELD

ImageName value(s):

DA BLOFIELD.JPG

DA BLOFIELD 3456.JPG

Is there a way to automatically pick the first value?

Thanks

Oli

Re: LIKE operator

jonathandienst — Tue, 17 Mar 2015 12:54:54 GMT

I think you need:

=if(ImageName LIKE '$(=PhotoLookup)*', ImageName, '')

HTH

Jonathan

Re: LIKE operator

Tue, 17 Mar 2015 13:01:00 GMT

Hi Jonathan

Thank you for your reply.

I may not have made myself very clear? What I have works to produce matching values. Unfortunately, the majority of results result more than one value in the ImageName field.

I would like to just return the first of the multiple matches...?

Is that possible and if so how?

Thanks

Oli

Re: LIKE operator

Tue, 17 Mar 2015 13:24:56 GMT

Hi,

Try using wildmatch.

Regards,

Nitesh

Re: LIKE operator

Tue, 17 Mar 2015 14:08:17 GMT

Hi,

LIKE function can works like this.

=if([FirstField] LIKE PhotoLookup &'*',[SecondField],'')

there are replace the any conditional string from FirstField instead of '*' .

Re: LIKE operator

rubenmarin — Tue, 17 Mar 2015 14:34:58 GMT

Hi Oli, you can use the MinString function to retrieve the first alphabetically sorted value:

=if(ImageName LIKE PhotoLookup&'*',MinString(ImageName),'')