topic Re: What is the Difference between Wildmatch and Mismatch function? in QlikView

What is the Difference between Wildmatch and Mismatch function?

jonesbrown — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I am new to Qlikview

What is the Difference between Wildmatch and Mismatch function?

Plz help.

Re: What is the Difference between Wildmatch and Mismatch function?

andrey_krylov — Sun, 30 Sep 2018 07:49:17 GMT

I hope it may help you understand

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

Re: What is the Difference between Wildmatch and Mismatch function?

Peter_Cammaert — Sun, 30 Sep 2018 10:15:11 GMT

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.

Re: What is the Difference between Wildmatch and Mismatch function?

qlikviewwizard — Mon, 01 Oct 2018 03:39:35 GMT

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 [

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

];