Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
sanketkhunte
Creator II
Creator II

Qlikview : Nested Expressions

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

0 Replies