Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Wildmatch and ** returning 0

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?

1 Solution

Accepted Solutions
marcus_sommer

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

- Marcus

View solution in original post

5 Replies
Anonymous
Not applicable
Author

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

marcus_sommer

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

Anonymous
Not applicable
Author

Hey Marcus, thank you for the reply.

Example: If I use the following expression...

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

With the following dataset...

  

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

It returns a 0 when it should return 4.

- Jimmy

marcus_sommer

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

- Marcus

Anonymous
Not applicable
Author

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