topic Re: Where filter using like and wildcard in QlikView

Where filter using like and wildcard

Fri, 03 Oct 2014 18:16:19 GMT

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*'

Re: Where filter using like and wildcard

Fri, 03 Oct 2014 18:36:01 GMT

Hi,

Try something like below:

LOAD BusinessUnit,

Re: Where filter using like and wildcard

Anonymous — Fri, 03 Oct 2014 18:40:15 GMT

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

Re: Where filter using like and wildcard

Fri, 03 Oct 2014 18:42:03 GMT

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

Re: Where filter using like and wildcard

Anonymous — Sat, 04 Oct 2014 01:53:22 GMT

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

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