0 Replies Latest reply: Jan 11, 2016 6:51 AM by Sanket Khunte RSS

    Qlikview : Nested Expressions

    Sanket Khunte

      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