Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
roccoxpecora
New Contributor III

Using Wildcard when creating a bucket

Hello Qlik users.

I'm creating buckets in a preceding load but with text values not numerical.

So currently it looks like:

     Load*,

       if([ImplementationProjectType]='Credit-Brand Flip','Credit',

               if([ImplementationProjectType]='Credit-Conversion','Credit',

                          if([ImplementationProjectType]='Debit-Existing','Debit','Other'))) as Imp_Type;

Is there a way to use wildcard(*) instead of writing each out value. I tried a couple ways and couldn't get it to work. If someone could help with the syntax to be able to utilize '*Credit*' somehow instead of writing that would great.

Thanks so much

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Using Wildcard when creating a bucket

Try the WildMatch() function:

  Load*,

       if(WildMatch( [ImplementationProjectType], '*Credit*'),'Credit',

                          if([ImplementationProjectType]='Debit-Existing','Debit','Other')) as Imp_Type;

2 Replies
MVP
MVP

Re: Using Wildcard when creating a bucket

Try the WildMatch() function:

  Load*,

       if(WildMatch( [ImplementationProjectType], '*Credit*'),'Credit',

                          if([ImplementationProjectType]='Debit-Existing','Debit','Other')) as Imp_Type;

Re: Using Wildcard when creating a bucket

In addition to doing it Stefan's way, you can also do it this way:

LOAD *,

          If(ImplementationProjectType LIKE '*Credit*', 'Credit',

          If(ImplementationProjectType = 'Debit-Existing', 'Debit', 'Other'));

LOAD ....