topic Re: Help with where clause in QlikView

Help with where clause

Mon, 29 Sep 2014 22:52:18 GMT

I want to exclude certain values from a field in my table. Right now, I'm already using a where clause, " where Location equal like 'M*'

But I also need another where clause that only brings in the bolded products but since 93UK is in california and not a 'MO' location. It also should not be brought in. What function could i use to do include two where clauses?

Product, Location

11LB, MO-11

12JK, MO-12

93UK, California

BA193, Florida

AB197, Louisiana

LA102, Kentucky

Re: Help with where clause

Tue, 30 Sep 2014 04:52:39 GMT

Hi,

What is the condition you're using to identify the products in bold ?

You will need to use "and" so it considers both of these conditions for the same record in the where clause.

Theoretically, if you have an additional flag that indicates a bold product, your code could look like this:

Load Product, Location

from ...

where Location like 'M*' AND Product_Bold = 1;

If this doesn't answer the request, it would be helpful if you can clarify more.

Re: Help with where clause

PrashantSangle — Tue, 30 Sep 2014 05:01:08 GMT

Hi,

If you want to load only Those product whose location start with M

then write

Load *

from tablename

where wildmatch(Location,'M*')

It will load only those location which started M or m

If you want to apply any other condition then use And / Or Keyword as per requirement.

Regards

Re: Help with where clause

jagan — Tue, 30 Sep 2014 05:04:30 GMT

Hi,

Try like this

Load Product, Location

from ...

where Location like 'M*' AND Match(Product, '11LB', '12JK', '93UK');

Regards,

Jagan.