Hi team,
Thank you.
I am trying to convert below SQL logic in Qlikview Expression -:
SELECT
COUNT(*)
FROM STAGE.TEMP1 T1
WHERE
(T1.SC_LAST_CANCELLED_DATE IS NOT NULL AND T1.SC_ENABLED_STATE <> 1)
NOT EXISTS
(
SELECT T2.PA_PARTNER_ACCOUNT_ID
FROM STAGE.TEMP2 T2
WHERE
T2.SC_START_DATE < V_END_DATE + 1 AND
T1.PA_PARTNER_ACCOUNT_ID = T2.PA_PARTNER_ACCOUNT_ID AND
(
T2.SC_LAST_CANCELLED_DATE >= V_END_DATE + 1 OR
)
)
GROUP BY T1.PA_PARTNER_ACCOUNT_ID);
Can anyone tell me how to handle
1. Not Exist in Qlikview Expression ?
2. How to use JOIN within Expression ? OR can i get list of dimentions from inner query to check ?
Thanks
Sanket