Convert multiple if conditions and aggr function into set analysis

Anuhyak1 — Thu, 17 Feb 2022 18:42:45 GMT

Can we convert multiple if conditions and aggr function into set analysis. Please ,help me with the expression. Attached screenshot for reference.

=AGGR(If(
(
((Count (Distinct If (
([Initial Receipt Date] >= %CPStartDateRRF AND [Initial Receipt Date] <= %CPEndDateRRF AND STATE_ID <> 1 AND [ARGUS J calculated] <> 'ARGUS J case' AND
(RPT_TYPE_ID <> 10001002 AND RPT_TYPE_ID <> 10001003 AND RPT_TYPE_ID <> 10000701 AND RPT_TYPE_ID <> 10000101))
OR ([CF Follow-Up Date]>= %CPStartDateRRF AND [CF Follow-Up Date] <= %CPEndDateRRF AND STATE_ID <> 1 AND [ARGUS J calculated] <> 'ARGUS J case' AND
(RPT_TYPE_ID <> 10001002 AND RPT_TYPE_ID <> 10001003 AND RPT_TYPE_ID <> 10000701 AND RPT_TYPE_ID <> 10000101) AND Significant = 'Yes')
, EVENT_COUNTER))+vAlpha)/$(vRRFn2))
/
((Count (Distinct If (
([Initial Receipt Date] >= %PPStartDateRRF AND [Initial Receipt Date] <= %PPEndDateRRF AND STATE_ID <> 1 AND [ARGUS J calculated] <> 'ARGUS J case' AND
(RPT_TYPE_ID <> 10001002 AND RPT_TYPE_ID <> 10001003 AND RPT_TYPE_ID <> 10000701 AND RPT_TYPE_ID <> 10000101))
OR ([CF Follow-Up Date]>= %PPStartDateRRF AND [CF Follow-Up Date] <= %PPEndDateRRF AND STATE_ID <> 1 AND [ARGUS J calculated] <> 'ARGUS J case' AND
(RPT_TYPE_ID <> 10001002 AND RPT_TYPE_ID <> 10001003 AND RPT_TYPE_ID <> 10000701 AND RPT_TYPE_ID <> 10000101) AND Significant = 'Yes')
, EVENT_COUNTER))+vAlpha)/ $(vRRFn1))
) >= vRRF
AND
(Count (Distinct If (
([Initial Receipt Date] >= %CPStartDateRRF AND [Initial Receipt Date] <= %CPEndDateRRF AND STATE_ID <> 1 AND [ARGUS J calculated] <> 'ARGUS J case' AND
(RPT_TYPE_ID <> 10001002 AND RPT_TYPE_ID <> 10001003 AND RPT_TYPE_ID <> 10000701 AND RPT_TYPE_ID <> 10000101))
OR ([CF Follow-Up Date]>= %CPStartDateRRF AND [CF Follow-Up Date] <= %CPEndDateRRF AND STATE_ID <> 1 AND [ARGUS J calculated] <> 'ARGUS J case' AND
(RPT_TYPE_ID <> 10001002 AND RPT_TYPE_ID <> 10001003 AND RPT_TYPE_ID <> 10000701 AND RPT_TYPE_ID <> 10000101) AND Significant = 'Yes')
, EVENT_COUNTER))) >=vN
,
'Yes',Null()),[Preferred Term])

Re: Convert multiple if conditions and aggr function into set analysis

Anuhyak1 — Fri, 18 Feb 2022 14:13:35 GMT

Please, any suggestions on set analysis expression for bottom if conditions?

topic Convert multiple if conditions and aggr function into set analysis in QlikView

Convert multiple if conditions and aggr function into set analysis

Re: Convert multiple if conditions and aggr function into set analysis