Set Analysis

[#1]

Hi All,

May I know hoe to write the below if condition in set analysis:

CODE:

if

(IncidentQualificationPerc='Approved',Count({$<INCIDENT_QUAL_STATUS={'Approved'}>}INCIDENT_NO)/Count(INCIDENT_NO),
if(IncidentQualificationPerc='Auto Qualified',Count({$<INCIDENT_QUAL_STATUS={'Auto Qualified'}>}INCIDENT_NO)/Count(INCIDENT_NO),
if(IncidentQualificationPerc='Disapproved',Count({$<INCIDENT_QUAL_STATUS={'Disapproved'}>}INCIDENT_NO)/Count(INCIDENT_NO

)
)))

[Gysbert_Wassenaar]

You're already using set analysis expressions in that expression. And you can't replace the if statements with a set analysis expression. A set is calculated once for the entire chart, not per row.