I have this query from an old app that I didn't build. I'm converting it from QV to QS.
SQL SELECT DISTINCT AR1.SOLD_TO_CUSTOMER_ID ,AR1.SHIP_DATE_ACTUAL FROM AR.RA_CUSTOMER_TRX_ALL AR1 WHERE AR1.SHIP_DATE_ACTUAL IS NOT NULL AND NOT EXISTS ( SELECT DISTINCT AR2.SOLD_TO_CUSTOMER_ID ,AR2.SHIP_DATE_ACTUAL FROM AR.RA_CUSTOMER_TRX_ALL AR2 WHERE AR1.SOLD_TO_CUSTOMER_ID = AR2.SOLD_TO_CUSTOMER_ID AND AR2.SHIP_DATE_ACTUAL < AR1.SHIP_DATE_ACTUAL AND AR2.SHIP_DATE_ACTUAL >= TRUNC(ADD_MONTHS(AR1.SHIP_DATE_ACTUAL, - 35), 'MM') );
Running this query as-is is brutally slow. I think it will run faster if I convert it to a normal Qlik Load.
I have loaded 2 copies of the table RA_CUSTOMER_TRX_ALL (RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_ALL2) into memory and want to replace this SQL query with normal Qlik Sense syntax.