Wildmatch example

[Anonymous]

Hii all,

Please share some basic wildmatch example.

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

Thanks

[prma7799]

Please check

wildmatch ‒ QlikView

[prma7799]

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

[Anonymous]

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

[prma7799]

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.

[veerendrakatika]

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

returns 1 if M = Veerendra

returns 2 if M = katikala

return 3 if M = middle name

[venkyraj]

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

[prma7799]

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