topic Re: Error in where SQL where exists condition in QlikView

Error in where SQL where exists condition

Anonymous — Thu, 02 Apr 2015 13:49:46 GMT

Hi all

i have found an error while using where exists condition directly from SQL in the qlikview script.

please refer the screen shot attached.

Kindly provide solution for this.

this is my script

CollectionRow:

LOAD DocEntry as ReceiptKey,

Collection_Amount,

NetCollection_Amount;

SQL SELECT

DocEntry,

SNo,

"Collection_Amount",

"NetCollection_Amount"

FROM "POS_HUB_NEW".dbo."Tbl_POS_Receipt_Row"

where exists(ReceiptKey,DocEntry)

;

thanks in advance

Siraj..

Re: Error in where SQL where exists condition

Anonymous — Thu, 02 Apr 2015 14:53:42 GMT

Hello,

WHERE must go below the LOAD block before the SQL block. Check help for syntax.

SQL statement is to be executed on DB side, whereas exists() is meant to be executed on QlikView side.

Serhan

Re: Error in where SQL where exists condition

buzzy996 — Thu, 02 Apr 2015 15:13:54 GMT

this field "ReceiptKey" information not available in ur select statement execution ,after select statement executed the result will pass to load statement.

right now ur field in load statement not in select statement,tht's the problem.