Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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

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

3 Replies
srikanthsri1
Valued Contributor

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

follow http://qlikshare.com/

all the function were demostrated with small examples

Luminary
Luminary

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

Thanks Raj.

Cheers,

DV

www.QlikShare.com

Not applicable

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

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.

Community Browser