topic Difference Between 'LIKE', 'MATCH','MIXMATCH','WILDMATCH'??? in QlikView

Difference Between 'LIKE', 'MATCH','MIXMATCH','WILDMATCH'???

Wed, 08 Aug 2012 12:50:57 GMT

Hi,

I am trying to understand the following functions

1. Like

2. match

3. Mixmatch

4.Wildmatch

Edit Script:

[Table1]:

Load * INLINE [

ID, Name, Dept

1,AAA,D1

2,BBB,D2

3,CCC,D3

4,BBB,D4

]

Assume now i have loaded this table "Table1"

I would require to create another table from 'table1' where the field "name" has the letter 'b' or letter 'c'

## This works##

[Like_Example]:

Load

ID as newID,

Name as newname,

Dept as newdept

Resident [Table1]

where

Name like ('*a*')

## THIS DOESNT WORKS##

[Like_Example]:

Load

ID as newID,

Name as newname,

Dept as newdept

Resident [Table1]

where

Name like ('*a*', '*c*')

If i need to search for both 'a' and 'c', then what is that i should be using?

How to use Match, Mixmatch and Wildmatch with the following example instead of like.

Can someone please help me in understanding this.

Thanks

Sarathi

Re: Difference Between 'LIKE', 'MATCH','MIXMATCH','WILDMATCH'???

Anonymous — Wed, 08 Aug 2012 13:04:54 GMT

follow http://qlikshare.com/

all the function were demostrated with small examples

Re: Difference Between 'LIKE', 'MATCH','MIXMATCH','WILDMATCH'???

IAMDV — Thu, 09 Aug 2012 12:26:11 GMT

Thanks Raj.

Cheers,

www.QlikShare.com

Re: Difference Between 'LIKE', 'MATCH','MIXMATCH','WILDMATCH'???

Thu, 17 Dec 2015 09:57:10 GMT

Dear sarathi,

in simple terms:

Match is use insted of writing multiple where conditions or if conditions

for example:

where product='a' and product ='b' and product='c';

by using match we can write like

match(product,a,b,c)

in the same way

wild match is to use match with wild characters %

and mix match is case insensitive

and like is instead of multiple where its same as match.