Skip to main content Skip to complementary content

match - script and chart function

The match function compares the first parameter with all the following ones and returns the number of the expression that matches. The comparison is case sensitive.

Syntax:  

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

 

Tip noteIf you want to use case insensitive comparison, use the mixmatch function. If you want to use case insensitive comparison and wildcards, use the wildmatch function.

Examples and results:  

Examples and results
Example Result
match( M, 'Jan','Feb','Mar')

returns 2 if M = Feb.

returns 0 if M = Aprorjan.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com