where condition in Script

[#1]

Hi

SalesOrderDetail where SalesOrderID in

(select SalesOrderID from SalesOrderHeader where OrderDate >= '$(vFromDate)' and OrderDate<='$(vToDate)');

This was written by usinf SQL, But i want Based on Load statement how can we write this.

[alexandros17]

LOAD

SalesOrderDetail where OrderDate >= $(vFromDate) and OrderDate<=$(vToDate);

SELECT SalesOrderDetail , SalesOrderID from SalesOrderHeader ;

[its_anandrjs]

Load your table like the below load statement but join type like Left,Right,Inner,Outer depends on your requirement please use according to that

In Qlikview

Load
SalesOrderID
From SalesOrderDetail;

Right Join


Load
SalesOrderID
From SalesOrderHeader
Where OrderDate >= '$(vFromDate)' and OrderDate <= '$(vToDate)';

[tresesco]

The same query can be used in qv using SQL Select like:

SQL Select

SalesOrderDetail <From DB Source> where SalesOrderID in

(select SalesOrderID from SalesOrderHeader where OrderDate >= '$(vFromDate)' and OrderDate<='$(vToDate)');

Assuming you have ODBC/OLEDB connection string is already there.