Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

I need to compare two fields in the same table.. Help

How can I nested select in the where to compare two fields from the same table? Something like the following code.

Thanks

select TRANSACTION_ID

from transactions

where ORGANIZATION_ID = 18

and CREATION_DATE between to_date('15-Oct-2015', 'DD-MON-YYYY') and to_date('15-Nov-2015', 'DD-MON-YYYY')

and TRANSACTION_TYPE = 'RECEIVE'

and TRANSACTION_ID not in (select PARENT_TRANSACTION_ID from transactions)

order by SHIPMENT_HEADER_ID

Community Browser