Qlikview Set Analysis

[sanketkhunte]

Hi there,

How can i convert below expression into Set Analysis ?

COUNT
(
DISTINCT
IF(
(
SC_ENABLED_STATE = 1 or
(DATE(SC_LAST_CANCELLED_DATE,'MM/DD/YYYY') = '' AND SC_ENABLED_STATE = 1) OR
(DATE(SC_LAST_CANCELLED_DATE,'MM/DD/YYYY') <= DATE(SC_START_DATE,'MM/DD/YYYY') ) OR
(DATE( SC_LAST_CANCELLED_DATE,'MM/DD/YYYY') >= DATE(v_EndDate,'MM/DD/YYYY')) or
(DATE(SC_LAST_CANCELLED_DATE,'MM/DD/YYYY') = '' AND SC_ENABLED_STATE <> 1 AND DATE(SC_MODIFY_DATE,'MM/DD/YYYY') >= DATE(v_EndDate,'MM/DD/YYYY') )
)

,ID))

Many Thanks

Sanket

[sanketkhunte]

Thank you for analysing whole things.

But for this KPI calculation we are using DATEUID fields and NOT any variables.

Here we need to compare 2 dates which are coming from same model with same format = YYYYMMDD.

Please don't refer any variable for this issue. I am using variables for other KPI calculation.

Can you send me test application with generating 2 dates comparison with set analysis. That would be really helpful to me ?

Many Many Thanks

Sanket

[sanketkhunte]

I don't that.. but we can create such using field for any implement ion.

[PrashantSangle]

Hi,

see below thread

Dates in Set Analysis

Regards

[sunny_talwar]

The if statement you are using, you are using it in a chart with Vendor Name as the dimension right?

[sunny_talwar]

Can you try this:

Count({<PARTNER_ACCOUNT_ID = {"=Num(PC_FIRST_ACTIVATED_DATE) <= Num(SC_LAST_CANCELLED_DATE)"}>} PARTNER_ACCOUNT_ID)

[sanketkhunte]

Perfect !! You are Great

Its working man....

Let me try with my other clauses and get back to you in case anything.

Many Many Thanks

Sanket

[sunny_talwar]

Awesome. I think I understood why it wasn't working before. The uniqueness was coming from Partner_Account_ID and not Vendor Name.