Set Analysis

Thu, 18 Jul 2013 09:57:44 GMT

Hi All,

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

CODE:

(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

)
)))

Re: Set Analysis

Gysbert_Wassenaar — Thu, 18 Jul 2013 10:06:28 GMT

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.

topic Set Analysis in QlikView

Set Analysis

Re: Set Analysis