Qlikview : Nested Expressions

[sanketkhunte]

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