topic Re: Set Analysis help!!!! in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-help/m-p/461583#M1164348 <HTML><HEAD></HEAD><BODY><P>Hi, Try this code:</P><P></P><P></P><P><STRONG>=Count({&lt;Comp_Status={'WorkingWith'},Terr_ChildCount={0}&gt;}if(isNull(Comp_Deleted)=-1,Comp_Status))</STRONG></P></BODY></HTML> Fri, 30 Nov 2012 11:38:26 GMT 2012-11-30T11:38:26Z Set Analysis help!!!! https://community.qlik.com/t5/QlikView/Set-Analysis-help/m-p/461580#M1164345 <HTML><HEAD></HEAD><BODY><P>can someone help convert this into set anlysis code thanks</P><P></P><P></P><P>COUNT (If (Comp_Status = 'WorkingWith' AND Terr_ChildCount = 0 AND isNull(Comp_Deleted),Comp_Status))</P></BODY></HTML> Fri, 23 Nov 2012 09:12:24 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-help/m-p/461580#M1164345 2012-11-23T09:12:24Z Re: Set Analysis help!!!! https://community.qlik.com/t5/QlikView/Set-Analysis-help/m-p/461581#M1164346 <HTML><HEAD></HEAD><BODY><P>COUNT ({&lt;Comp_Status ={ 'WorkingWith' }, Terr_ChildCount = {0} AND Comp_Deleted={''}&gt;}Comp_Status)</P><P></P><P>Try this expresion.</P></BODY></HTML> Fri, 23 Nov 2012 09:22:57 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-help/m-p/461581#M1164346 perumal_41 2012-11-23T09:22:57Z Re: Set Analysis help!!!! https://community.qlik.com/t5/QlikView/Set-Analysis-help/m-p/461582#M1164347 <HTML><HEAD></HEAD><BODY><P></P><P>Hi,</P><P></P><P>Try this expression</P><P></P><P>=Count( {&lt;Comp_Status={'WorkingWith'}, Terr_ChildCount={'0'}, Comp_Deleted-={'*'}&gt;} Comp_Status)</P><P></P><P>Regards,</P><P>jagan.</P></BODY></HTML> Fri, 23 Nov 2012 09:39:41 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-help/m-p/461582#M1164347 jagan 2012-11-23T09:39:41Z Re: Set Analysis help!!!! https://community.qlik.com/t5/QlikView/Set-Analysis-help/m-p/461583#M1164348 <HTML><HEAD></HEAD><BODY><P>Hi, Try this code:</P><P></P><P></P><P><STRONG>=Count({&lt;Comp_Status={'WorkingWith'},Terr_ChildCount={0}&gt;}if(isNull(Comp_Deleted)=-1,Comp_Status))</STRONG></P></BODY></HTML> Fri, 30 Nov 2012 11:38:26 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-help/m-p/461583#M1164348 2012-11-30T11:38:26Z