Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
sanketkhunte
Creator II
Creator II

Qlikview Set Analysis

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

46 Replies
sanketkhunte
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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

Great dreamer's dreams never fulfilled, they are always transcended.
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
Creator II
Creator II
Author

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.