topic Re: what is a match function? in QlikView

what is a match function?

Sat, 20 Sep 2014 06:58:25 GMT

hi friend's please tell me any one what is a match function with example

Re: what is a match function?

arulsettu — Sat, 20 Sep 2014 07:03:41 GMT

The match function performs a case sensitive comparison.

for ex

if you have list of countries. requirement is display ex: india, usa, canada, uk alone.

for that

if(match(country, 'india', 'usa', 'canada', 'uk'),country)

will give the result

hope it helps

Re: what is a match function?

Sat, 20 Sep 2014 07:05:13 GMT

than q sir

Re: what is a match function?

arulsettu — Sat, 20 Sep 2014 07:07:14 GMT

if answer is correct please close the thread it would be helpful to others

Re: what is a match function?

MK_QSL — Sat, 20 Sep 2014 08:30:40 GMT

Arul has already replied on your post... But I would advice you to ready the QlikView reference manual before posting such a basic question. Also, you can search on QlikCommunity for previous questions on same topics. This would help you to get answer without waiting .....

Particular to this topic, you can also check WildMatch and MixMatch functions.. ...

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

Re: what is a match function?

arixooo123 — Sat, 20 Sep 2014 08:33:54 GMT

I have used that for sorting different values of an attribute in charts

=match(attribute,'value1','value2',....)