topic Re: Wildmatch and ** returning 0 in QlikView

Wildmatch and ** returning 0

Anonymous — Mon, 17 Sep 2018 16:07:00 GMT

Whenever I try to use the wildmatch function or search using **, I get a return of 0. I have gotten around this in the past by using filters, but it has become burdensome.

Is this an issue I have within my settings?

Re: Wildmatch and ** returning 0

Anonymous — Mon, 17 Sep 2018 16:09:53 GMT

I know the function is correct because I took the exact line and ran it on a colleages computer and got a result.

So I am thinking it must be an issue within settings

Re: Wildmatch and ** returning 0

marcus_sommer — Tue, 18 Sep 2018 13:22:55 GMT

It sounds strange. Does the question mark work as a wildcard? Could you give an example of such wildmatch-expression and a search-string?

- Marcus

Re: Wildmatch and ** returning 0

Anonymous — Tue, 18 Sep 2018 13:39:13 GMT

Hey Marcus, thank you for the reply.

Example: If I use the following expression...

Count({<ActivityType={'*Meeting*'}>}[ActivityId])

With the following dataset...

ActivityID	ActivityType
1	Call
2	Meeting
3	Business Meeting
4	Call
5	Email
6	Call
7	Business Meeting
8	Meeting
9	Call
10	Email

It returns a 0 when it should return 4.

- Jimmy

Re: Wildmatch and ** returning 0

marcus_sommer — Wed, 19 Sep 2018 06:33:44 GMT

Try it again by adjusting the fieldname within the expression from: ActivityId to ActivityID.

- Marcus

Re: Wildmatch and ** returning 0

Anonymous — Wed, 19 Sep 2018 13:11:27 GMT

Thank you marcus_sommer! It was a combination of changing Id to ID and '*Meeting*' to "*Meeting*".