2 Replies Latest reply: Mar 8, 2016 7:28 PM by Sunny Talwar RSS

    Using Wildcard when creating a bucket

    Rocco Pecora

      Hello Qlik users.

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

      So currently it looks like:


             if([ImplementationProjectType]='Credit-Brand Flip','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