topic Re: Wildmatch example in QlikView

Wildmatch example

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

Hii all,

Please share some basic wildmatch example.

I tried to search but there nested data in other example i found.

Thanks

Re: Wildmatch example

prma7799 — Fri, 23 Jun 2017 06:58:36 GMT

Please check

wildmatch ‒ QlikView

Re: Wildmatch example

prma7799 — Fri, 23 Jun 2017 07:03:03 GMT

Match() is used for a case sensitive comparison. It matches the exact searchstring you pass in the function.

for Example: Match(Name,'Raja') , returns true if a person's name is exactly Raja (R caps).

WildMatch is used for a match where a string can be part of the search string.

For example :Match(Name,'Raja') will return true if a person's name is Raja, Maharaja, Rajan, or Rajat or some other string containing Raja in it.

MixMatch is same as Match but it is case insensitive.

PFA

Re: Wildmatch example

Anonymous — Fri, 23 Jun 2017 07:05:57 GMT

I go through with help_wildmatch but i need some proper example which understand by easily.

Re: Wildmatch example

prma7799 — Fri, 23 Jun 2017 07:06:21 GMT

Match() is used for a case sensitive comparison. It matches the exact searchstring you pass in the function.

for Example: Match(Name,'Raja') , returns true if a person's name is exactly Raja (R caps).

WildMatch is used for a match where a string can be part of the search string.

For example :Match(Name,'Raja') will return true if a person's name is Raja, Maharaja, Rajan, or Rajat or some other string containing Raja in it.

MixMatch is same as Match but it is case insensitive.

Re: Wildmatch example

veerendrakatika — Fri, 23 Jun 2017 07:08:22 GMT

Ex : wildmatch (M, 'Veerendra*', 'katikala#', 'Middle name' )

returns 1 if M = Veerendra

returns 2 if M = katikala

return 3 if M = middle name

Re: Wildmatch example

venkyraj — Fri, 23 Jun 2017 07:08:25 GMT

WildMatch Resturned the search string by using * and it is case insensitive,

ex;wildmatch(Month,'*h','f*','fe*'..,)

in this case its returns the search string of month field ended with ,'h',started with 'f'.

Thanks

venky

Re: Wildmatch example

prma7799 — Fri, 23 Jun 2017 07:35:11 GMT

Hi Aniket,

You have been very active on the community but I find it hard to believe there is not one thread that you have received an answer to!

Can you take some time to mark correct / useful response's to your posts for the benefit of other people who may have a similar query?

Please check aniket_2701

Read the below thread please.

Qlik Community Tip: Marking Replies as Correct or Helpful