In this snippet we have to select item as per below SQL Logic in QlikView.
(Select top 1 INSPD.UpdatedOn from InspAppDet INSPD where INSPD.ConID=AO.ConID and INSPD.IsAcknowledged='Y' and INSPD.IsTransActive='N' and INSPD.IsApprovedBy='Y' ORDER BY CreatedOn desc) 'L_APP_A_O'
How can I achieve this, here two different tables are referred and two different conditions for join have been used and this table can be used by other available tables
