topic Re: Where Clause with Wildcard in QlikView

Where Clause with Wildcard

ndenicola — Thu, 24 Mar 2016 15:54:26 GMT

Hello Everyone,

In my data set, there is a column called SUPPORTTEAM that displays all the support teams for the company, however I am trying to create a where clause that limits the SUPPORTTEAM to only Member Services and Service Executives. This would mean limiting the data to any field in the SUPPORTTEAM column that begins with MemberServices_ or SC_.

I created a WHERE clause at the bottom of my script (listed below) but Qlik Sense is giving me a "Line error" message.

WHERE [SUPPORTTEAM] = ('MemeberServices*' OR 'SC*');

Any suggestions?

Re: Where Clause with Wildcard

sunny_talwar — Thu, 24 Mar 2016 17:55:32 GMT

May be this:

Where WildMatch(SUPPORTTEAM, 'MemberServices*'', 'SC*');

Where WildMatch(SUPPORTTEAM, 'MemberServices*', 'SC*');

I think there was a typo in MemberServices.

Re: Where Clause with Wildcard

ndenicola — Thu, 24 Mar 2016 18:03:04 GMT

It was the typo. The WILDMATCH didn't work, but the original clause with the fixed field name did. Thank you!

Re: Where Clause with Wildcard

sunny_talwar — Thu, 24 Mar 2016 18:52:17 GMT

Very strange,I would not have thought this expression to be correct

WHERE [SUPPORTTEAM] = ('MemeberServices*' OR 'SC*');

Re: Where Clause with Wildcard

Thu, 24 Mar 2016 19:00:19 GMT

You can either use LIKE or WILDMATCH function. But as you stated, WILDMATCH is not working. May be you can try with WildMatch with mix match cases.

WildMatch(SUPPORTTEAM,'*member*s*vices','SC*)

Re: Where Clause with Wildcard

sunny_talwar — Thu, 24 Mar 2016 19:02:35 GMT

dathu.qv‌ I can understand why WildMatch did not work, but do you know how the other syntax is working?

Where [SUPPORTTEAM] = ('MemeberServices*' OR 'SC*');

Re: Where Clause with Wildcard

Saravanan_Desingh — Thu, 24 Mar 2016 19:19:59 GMT

You can also try like this..

Where [SUPPORTTEAM] = If([SUPPORTTEAM] Like 'MemeberServices*'

[SUPPORTTEAM] Like 'SC*',

[SUPPORTTEAM])

;

Re: Where Clause with Wildcard

Thu, 24 Mar 2016 20:11:38 GMT

Sunny, as per knowledge, the Initial syntax won't work and TS(thread starter) mentioned very first beginning.

I may suspect , TS tweak the values on the field and come with specific working pattern on the WildMatch.