What is the Uses of match and mismatch Functions?

[jonesbrown]

Hi All,

I am new to Qlikview

What is the Uses of match and mismatch Functions?

plz help.

[YoussefBelloum]

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]

Thank you sir

[YoussefBelloum]

you're welcome

[sergio0592]

Hi,

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