topic How to translate IN SQL STATMENT in QlikView

How to translate IN SQL STATMENT

Mon, 14 May 2012 10:58:00 GMT

I need to check different values from different tables. One is from a sql query another one is from an excel.

I would like to do something like that:

SELECT CarTypeId FROM CarType
WHERE (CarTypeId NOT IN
(SELECT DISTINCT CarTypeId FROM Cars)
)

But from the qlikview script ?

Is it feasable?

Thanks in advance

jagannalla — Mon, 14 May 2012 11:16:53 GMT

Hello,

First load the field from excel sheet. Qv has Exists function which allows to check with loaded field data.Use that for sql data load viceversa..

Temp:

Load CarTypeId From ExcelData;

Main:

Load CarTypeId, 1 as CountValue

From SqlData

Where Not Exists(CarTypeId);

Drop Table Temp;