topic Re: in/contain clause in QlikView

in/contain clause

Wed, 30 Jul 2014 07:59:24 GMT

I want a function that is the same as in clause in sql and crystal. I want to check if a particular field contains a particular word. is that possible?

I want to use it as an expression in a table

Re: in/contain clause

Wed, 30 Jul 2014 08:07:10 GMT

take a look at the Match() function if you are looking at the whole field value or wildmatch() if looking at a section

You'll find both in the QV manual with further details

hope that helps

Joe

Re: in/contain clause

jonathandienst — Wed, 30 Jul 2014 08:09:28 GMT

You can use Index() or WildMatch to do that:

=Index(Field, 'phrase')

=WildMatch(Field, '*phrase*')

=Match(Field, 'prase') // exact match

=Field = 'phrase' // exact match

These will return 0 is 'phrase' is not in Field. If you want to use it to select rows where the Field = 'phrase', then

LOAD *

FROM Table.qvd

Where WildMatch(Field, '*phrase*') // whichever works best

HTH

Jonathan

Re: in/contain clause

Anonymous — Wed, 30 Jul 2014 08:09:32 GMT

Hi,

Below qlikview function will help you to achieve same result as SQL IN clause,

Match( Month, 'Jan','Feb','Mar') // This function perform case sensitive comparison

MixMatch( Month, 'Jan','Feb','Mar') // This function perform case insensitive comparison

WildMatch( Month, 'ja*','fe?','mar') // This function perform case insensitive comparison and permits the use of wildcard characters.

Hope this helps you.