topic Re: WildMatch not working in QlikView

WildMatch not working

Wed, 29 Mar 2017 21:41:46 GMT

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!

Re: WildMatch not working

rwunderlich — Wed, 29 Mar 2017 21:49:15 GMT

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

Re: WildMatch not working

Wed, 29 Mar 2017 21:59:22 GMT

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.

Re: WildMatch not working

rwunderlich — Thu, 30 Mar 2017 03:19:17 GMT

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

-Rob

Re: WildMatch not working

Anil_Babu_Samineni — Thu, 30 Mar 2017 03:58:49 GMT

Would you share few values and then use expression then see

Re: WildMatch not working

sunny_talwar — Thu, 30 Mar 2017 11:24:51 GMT

May be this

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

Re: WildMatch not working

Thu, 30 Mar 2017 15:27:45 GMT

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

Re: WildMatch not working

Thu, 30 Mar 2017 15:28:57 GMT

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 ****/