topic where condition in Script in QlikView

where condition in Script

Fri, 30 May 2014 06:23:02 GMT

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.

Re: where condition in Script

alexandros17 — Fri, 30 May 2014 06:28:19 GMT

LOAD

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

SELECT SalesOrderDetail , SalesOrderID from SalesOrderHeader ;

Re: where condition in Script

its_anandrjs — Fri, 30 May 2014 06:29:38 GMT

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)';

Re: where condition in Script

tresB — Fri, 30 May 2014 06:29:47 GMT

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.