Qlikview : Nested Expressions

sanketkhunte — Mon, 11 Jan 2016 11:51:01 GMT

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

topic Qlikview : Nested Expressions in QlikView