What is the Difference between Wildmatch and Mismatch function?

[jonesbrown]

Hi All

I am new to Qlikview

What is the Difference between Wildmatch and Mismatch function?

Plz help.

[andrey_krylov]

I hope it may help you understand

Re: can any one explain mixmatch,wildmatch with example?

[Peter_Cammaert]

QlikView has no MisMatch function. As Andrey implicitly pointed out, QlikView does have a MixMatch function.

MixMatch is analogous to the regular Match string comparison function. But while Match performs a case-sensitive match ('abc' is different from 'ABC'), MixMatch performs a case-insensitive match ('abc' is equal to 'ABC').

Both functions don't allow wildcard expressions. Or in other words, they treat wildcard characters as regular characters. WildMatch on the other hand allows for special wildcard treatment (e.g. '*' matches multiple unspecified characters, and '?' matches a single unspecified character), and performs a case-insensitive match as well.

[qlikviewwizard · Accepted solution]

Hi,

There is not Mismatch function in Qlikview but it is mixmatch.

Data:

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

mixmatch( M, 'jan','Feb','mar') as mixmatch;

LOAD Date#(M,'MMM') as M INLINE [

M

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

];