Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Where filter using like and wildcard

  I have a list of Business Units 10100000, 10200100, 10200150, 1040000, etc.

    

I want to pull data only for business units that start with 10200XXX.

    

If I use the code below and I do where WWBusUnit = "10200100" it
will return the WWCustomerIndustry for that one Business Unit. However if I try
to use a wild card, it does not return any WWCustomerIndustry records.

   

What is the appropriate syntax or method to do what I want?

    

LOAD WWBusUnit,
WWCustomerIndustry

FROM
WWCustomerIndustry.qvd
(
qvd)

Where
WWBusUnit Like '*10200*'

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

Try something like below:

LOAD BusinessUnit,

     Category

FROM

E:\qlikview\Source\wildcard_Demo.xlsx

(ooxml, embedded labels, table is Sheet1)

where BusinessUnit like '1020*';

View solution in original post

4 Replies
Not applicable
Author

Hi,

Try something like below:

LOAD BusinessUnit,

     Category

FROM

E:\qlikview\Source\wildcard_Demo.xlsx

(ooxml, embedded labels, table is Sheet1)

where BusinessUnit like '1020*';

Anonymous
Not applicable
Author

Hi!

To get everything that starts with 10200, you can use this:

Where WWBusUnit Like '10200*';


I believe that in this case like is the best way.


Regards,

Gabriel

Not applicable
Author

Yes that did it.  I can't believe I was that close but couldn't get it.  Appreciate the help

Anonymous
Not applicable
Author

I would use; where wildmatch(BusinessUnit, '10200*');

Gives the same result, but might be more performant in some cases (e.g. large data sets)