topic Convert If condition into Set analysis expression in QlikView

Convert If condition into Set analysis expression

Anuhyak1 — Thu, 10 Feb 2022 17:11:16 GMT

Can we convert below if condition to a set analysis expression to make it work. Please ,help me with suggestions.

Count (Distinct
If (
([Initial Receipt Date] >= %CPStartDateRRF AND [Initial Receipt Date] <= %CPEndDateRRF AND RRF_State_RPT_Flag = 1)
OR ([CF Follow-Up Date]>= %CPStartDateRRF AND [CF Follow-Up Date] <= %CPEndDateRRF AND RRF_State_RPT_Flag = 1 AND Significant = 'Yes')
, EVENT_COUNTER)
)

Re: Convert If condition into Set analysis expression

anat — Fri, 11 Feb 2022 08:46:10 GMT

Count (
{<[Initial Receipt Date]={">=$(%CPStartDateRRF)"},[Initial Receipt Date]={"<=$(%CPEndDateRRF)"},RRF_State_RPT_Flag={1}>
+
<[CF Follow-Up Date]={">=$(%CPStartDateRRF)"},[CF Follow-Up Date]={"<=$(%CPEndDateRRF)"},RRF_State_RPT_Flag={1},Significant={'Yes'}>
}
Distinct EVENT_COUNTER)

Re: Convert If condition into Set analysis expression

Harvey — Mon, 14 Feb 2022 03:52:45 GMT

@Anuhyak1 wrote:

Can we convert below if condition to a set analysis expression to make it work. Please ,help me with suggestions.

Count (Distinct my ford benefits
If (
([Initial Receipt Date] >= %CPStartDateRRF AND [Initial Receipt Date] <= %CPEndDateRRF AND RRF_State_RPT_Flag = 1)
OR ([CF Follow-Up Date]>= %CPStartDateRRF AND [CF Follow-Up Date] <= %CPEndDateRRF AND RRF_State_RPT_Flag = 1 AND Significant = 'Yes')
, EVENT_COUNTER)
)

If you just want to ignore some filters you can use your if expression combined with set analysis to ignore