topic I need to compare two fields in the same table.. Help in QlikView https://community.qlik.com/t5/QlikView/I-need-to-compare-two-fields-in-the-same-table-Help/m-p/924415#M645206 <HTML><HEAD></HEAD><BODY><P>How can I nested select in the where to compare two fields from the same table? Something like the following code.</P><P>Thanks</P><P></P><P></P><P>select <SPAN style="font-size: 13.3333px;">TRANSACTION_ID</SPAN> </P><P>from transactions</P><P>where ORGANIZATION_ID = 18</P><P>and CREATION_DATE between to_date('15-Oct-2015', 'DD-MON-YYYY') and to_date('15-Nov-2015', 'DD-MON-YYYY')</P><P>and TRANSACTION_TYPE = 'RECEIVE'</P><P>and TRANSACTION_ID not in (select PARENT_TRANSACTION_ID from transactions)</P><P>order by SHIPMENT_HEADER_ID</P></BODY></HTML> Mon, 30 Nov 2015 23:38:41 GMT 2015-11-30T23:38:41Z I need to compare two fields in the same table.. Help https://community.qlik.com/t5/QlikView/I-need-to-compare-two-fields-in-the-same-table-Help/m-p/924415#M645206 <HTML><HEAD></HEAD><BODY><P>How can I nested select in the where to compare two fields from the same table? Something like the following code.</P><P>Thanks</P><P></P><P></P><P>select <SPAN style="font-size: 13.3333px;">TRANSACTION_ID</SPAN> </P><P>from transactions</P><P>where ORGANIZATION_ID = 18</P><P>and CREATION_DATE between to_date('15-Oct-2015', 'DD-MON-YYYY') and to_date('15-Nov-2015', 'DD-MON-YYYY')</P><P>and TRANSACTION_TYPE = 'RECEIVE'</P><P>and TRANSACTION_ID not in (select PARENT_TRANSACTION_ID from transactions)</P><P>order by SHIPMENT_HEADER_ID</P></BODY></HTML> Mon, 30 Nov 2015 23:38:41 GMT https://community.qlik.com/t5/QlikView/I-need-to-compare-two-fields-in-the-same-table-Help/m-p/924415#M645206 2015-11-30T23:38:41Z