Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

jonesbrown
New Contributor III

What is the Uses of match and mismatch Functions?

Hi All,

I am new to Qlikview

What is the Uses of match and mismatch Functions?

plz help.

4 Replies
YoussefBelloum
Esteemed Contributor

Re: What is the Uses of match and mismatch Functions?

Hi,

making script / chart conditions/calculations on a field for example

if(match(field,'value1,'value2'...), 'make something', 'make something else') as FIELD

or

if(NOT match(field,'value1,'value2'...), 'make something', 'make something else') as FIELD


https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ConditionalFun...

jonesbrown
New Contributor III

Re: What is the Uses of match and mismatch Functions?

Thank you sir

YoussefBelloum
Esteemed Contributor

Re: What is the Uses of match and mismatch Functions?

you're welcome

sergio0592
Valued Contributor II

Re: What is the Uses of match and mismatch Functions?

Hi,

Mismatch function doesn't exists. It's Mixmatch() function. It performs a case insensitive comparison whereas match() performs a case sensitive.