Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis

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

)
)))

1 Reply
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.


talk is cheap, supply exceeds demand