
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is the Difference between Wildmatch and Mismatch function?
Hi All
I am new to Qlikview
What is the Difference between Wildmatch and Mismatch function?
Plz help.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
];


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I hope it may help you understand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
];
