Error in where SQL where exists condition

[Anonymous]

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..

[Anonymous]

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.

BR

Serhan

[buzzy996]

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.