Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

can any one explain mixmatch,wildmatch with example?

can any one explain mixmatch,wildmatch with example?

and match function with same example
?

match function i did   pls explain me same example in mixmatc and wildmatch functions?

LOAD * INLINE [

Year, Test1, Test2

2000, 23 ,34

2001, 34, 65

2002, 22 ,33

2003, 45 ,67

2004, 34 ,34

2005, 45 ,55

2006, 56, 67

2007, 34, 11

2008, 23 ,34

2009, 34, 65

2010, 22 ,33

2011, 45 ,67

2012, 34 ,34

2013, 45 ,55

2014, 56, 67

2015, 34, 11

]

where not match (Year,'2000','2001','2002','2003','2004');    

1 Solution

Accepted Solutions
SergeyMak
Partner Ambassador
Partner Ambassador

Hi,

The information from the help:

match( str, expr1 [ , expr2,...exprN ] )

The match function performs a case sensitive comparison.

Example:

match( M, 'Jan','Feb','Mar')

returns 2 if M = Feb

returns 0 if M = Apr or jan


mixmatch( str, expr1 [ , expr2,...exprN ] )


The mixmatch function performs a case insensitive comparison.

Example:

mixmatch( M, 'Jan','Feb','Mar')

returns 1 if M = jan

wildmatch( str, expr1 [ , expr2,...exprN ] )

The wildmatch function performs a case insensitive comparison and permits the use of wildcard characters ( * and ?) in the comparison strings.

Example:

wildmatch( M, 'ja*','fe?','mar')

returns 1 if M = January

returns 2 if M = fex

Regards,

Sergey

Regards,
Sergey

View solution in original post

6 Replies
SergeyMak
Partner Ambassador
Partner Ambassador

Hi,

The information from the help:

match( str, expr1 [ , expr2,...exprN ] )

The match function performs a case sensitive comparison.

Example:

match( M, 'Jan','Feb','Mar')

returns 2 if M = Feb

returns 0 if M = Apr or jan


mixmatch( str, expr1 [ , expr2,...exprN ] )


The mixmatch function performs a case insensitive comparison.

Example:

mixmatch( M, 'Jan','Feb','Mar')

returns 1 if M = jan

wildmatch( str, expr1 [ , expr2,...exprN ] )

The wildmatch function performs a case insensitive comparison and permits the use of wildcard characters ( * and ?) in the comparison strings.

Example:

wildmatch( M, 'ja*','fe?','mar')

returns 1 if M = January

returns 2 if M = fex

Regards,

Sergey

Regards,
Sergey
sujeetsingh
Master III
Master III

The Match() function can be used to compare strings, fields and variables using the string expression. The result of comparison is always an integer that shows the match expression. In the Match() function if no value is returned then the result would be 0. If an integer value is returned then the result would be 1. This function can used with the expression and it cannot be used with a chart, list box or text box. The Match() function will be used for a specified item in an array and then return the item in a specified position in a specified order. In the Match() the comparison is case sensitive.

Where to use Match() function

  • The Match() function can be used in a QlikView application for the "Switch Case" statement.
  • It can be also used as a substitution in an If statement.
  • It can be used in a Load Script as an In statement.
  • It can be used to find a match without using the duplicate value.
jagan
Luminary Alumni
Luminary Alumni

Hi Manoj,

In simple

Match() - is check whether the value is exists in the given set of values, it is similar IN() in Sql query

Syntax:

Match(DimensionName, Value1, Value2, Value3) etc.

Example:

Match(Month, 'Jan', 'Fab', 'Mar') -- If Month=Jan  returns 1, Month = Feb returns 2.........

Note: Match is case sensitive Jan and jan are different values.

Mixmatch() - is check whether the value is exists in the given set of values, it is similar IN() in Sql query, in this the case is not considered both Jan and jan are same.

Syntax:

Mixmatch(DimensionName, Value1, Value2, Value3) etc.

Example:

Mixmatch(Month, 'Jan', 'Fab', 'Mar') -- If Month=Jan  returns 1, Month = jan returns 1.........

Note: Mixmatch is case insensitive Jan and jan are same.

WildMatch - With this you can use wildcard characters to check the values  also this is case insensitive

Syntax:

Wildmatch(DimensionName, Value1, Value2, Value3) etc.

Example:

Mixmatch(Month, 'Jan', 'jan*', 'Mar') -- If Month=Jan  returns 1, Month = jan returns 1........., if Month ='janu' returns 2

Hope this helps you.

Regards,

Jagan.

its_anandrjs

Hi,

Or well explained in this thread also check this

Conditional Functions

Regards

Anand

Not applicable
Author

Wildmatch ex:

LOAD * INLINE [

Year, Test1, Test2

2000, 23 ,34

2001, 34, 65

2002, 22 ,33

2003, 45 ,67

2004, 34 ,34

2005, 45 ,55

2006, 56, 67

2007, 34, 11

2008, 23 ,34

2009, 34, 65

2010, 22 ,33

2011, 45 ,67

2012, 34 ,34

2013, 45 ,55

2014, 56, 67

2015, 34, 11

]

where not WildMatch (Year,'201*'); 

in above case year 2010 onward will not load.

Not applicable
Author

mixmatch example:

LOAD * INLINE [

Year,Month, Test1, Test2

2000,JAN, 23 ,34

2001,FEB, 34, 65

2002,mAR, 22 ,33

2003,jan, 45 ,67

2004,feb, 34 ,34

2005,Mar, 45 ,55

2006,JAn, 56, 67

2007,fEB, 34, 11

2008,MAR, 23 ,34

2009,jan, 34, 65

2010,feb, 22 ,33

2011,mar, 45 ,67

2012, jan,34 ,34

2013, feb,45 ,55

2014,mar, 56, 67

2015,jan, 34, 11

]

where  MixMatch (Month,'jan','feb','mar'); 

this will load all data because mixmatch will do non casesensitivie comparison