Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joshakehurst
New Contributor III

WildMatch and If statement

I'm having a mental block today on WildMatch parameter.  Any suggestions on how to write an expression to EXCLUDE a userID prefix from a data set.  I assume I could use a <> parameter, but can't figure it out. 

Example to include anything 'Test*' but would like to exclude test from the data set. 

if(WildMatch([UserId],'Test*'), [UserId]) 

1 Solution

Accepted Solutions

Re: WildMatch and If statement

It's not quite clear for me what do you are meaning with "exclude test from the data set"? Here a variance to your expression which might be more suitable:

if(not WildMatch([UserId],'Test*'), [UserId], null())

- Marcus

1 Reply

Re: WildMatch and If statement

It's not quite clear for me what do you are meaning with "exclude test from the data set"? Here a variance to your expression which might be more suitable:

if(not WildMatch([UserId],'Test*'), [UserId], null())

- Marcus

Community Browser