topic How to use 'In' within where keyword? in QlikView

How to use 'In' within where keyword?

Mon, 21 Feb 2011 08:51:14 GMT

Hi All,

Does QV where keyword supports 'In' word like it is in SQL?

For example:

Load * from table where Field in (1,2)

Thanks.

How to use 'In' within where keyword?

Miguel_Angel_Baeyens — Mon, 21 Feb 2011 09:13:39 GMT

Hello,

I'd use one of the following. In case of very few values, Match()

Customers:LOAD *FROM File.qvd (qvd)WHERE Match(CustomerID, 'AAA', 'BBB');

If there are several possibilities or they depend on other field, Exists():

Sales:LOAD *FROM Invoices.qvd (qvd); Customers:LOAD *FROM Customers.qvd (qvd)WHERE Exists(CustomerID); // Will load only those CustomerID present in the Sales table as well

Hope this helps

How to use 'In' within where keyword?

tresB — Mon, 21 Feb 2011 09:16:03 GMT

You can have a look at EXISTS function or MATCH function.

Regards, tresesco

How to use 'In' within where keyword?

Mon, 21 Feb 2011 09:18:03 GMT

You can use IN while fetching data from database

for example:

--------------------------------------------

Load

A,B,C

SQL SELECT *
FROM DB.dbo."Table1"
where upper(status)in('ACTIVE','ABC');

--------------------------------------------

You can not use IN while fetching data from QVD