WildMatch not working

[#1]

Hi,

The following expression works:

=WildMatch(OSUser(), '*abc') // this returns me -1 which is true

But when I try using the following expression, where UserPermitted has values *abc,*edf,*yfy. The expression below does not work

=WildMatch(OSUser(), (Concat(DISTINCT chr(39)&'*' & [UserPermitted]&chr(39) , ', '))) // this returns me 0, although it should return me -1

Please suggest!

[rwunderlich]

WildMatch() cannot use a dynamic computed list in this fashion. You must use DSE to syntax to cause the parameter list to be built before the WildMatch() is evaluated. Try:

=WildMatch(OSUser(), $(=(Concat(DISTINCT chr(39)&'*' & [UserPermitted]&chr(39) , ', '))))

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[#3]

Thank you for the response. It returns me a value of 3, but it should ideally return 1.

Note:The field UserPermitted has 3 values in it.

[rwunderlich · Accepted solution]

It returns 3 because it matches the 3rd value.  Why do you want it to return 1?

-Rob

[Anil_Babu_Samineni]

Would you share few values and then use expression then see

[sunny_talwar]

May be this

SubStringCount('|' & Concat(DISTINCT UserPermitted, '|,|') & '|', '|' & SubField(OSUser(), '\', -1) & '|')

[#7]

I was under the conception that the function would just return 1. Thanks for the clarification

[#8]

Thanks Sunny, this also works and is a correct answer. Wanted to mark your answer as correct too. But this website would not let me do it.

/**** This is also a correct answer ****/