topic Re: What is the error in this set expression? in QlikView https://community.qlik.com/t5/QlikView/What-is-the-error-in-this-set-expression/m-p/719840#M258539 <HTML><HEAD></HEAD><BODY><P>Hi TheVIlla,</P><P></P><P>=Count(DISTINCT{$&lt;EmployeeBucket={'&gt;90 &lt;=100'}&gt;}EmployeeBucket)</P><P>use this expression in text object may gives the result.</P></BODY></HTML> Thu, 21 Aug 2014 10:03:19 GMT 2014-08-21T10:03:19Z What is the error in this set expression? https://community.qlik.com/t5/QlikView/What-is-the-error-in-this-set-expression/m-p/719836#M258535 <HTML><HEAD></HEAD><BODY><P>HI All</P><P></P><P></P><P>i am using the below set expression to fing the count of employees who belongs to 90 and 100 but it is showing '-' for me?</P><P></P><P>=if(sum( distinct EmployeeBucket &gt;90) and sum(distinct EmployeeBucket &lt;=100),Count( DISTINCT [Employee Number]))&nbsp; </P><P></P><P></P><P></P><P>pls help me to correct issue</P><P></P><P>Thanks in advance</P><P><SPAN style="color: #000000; font-size: 10pt; font-family: 'Segoe UI';"><BR /></SPAN></P></BODY></HTML> Thu, 21 Aug 2014 09:31:55 GMT https://community.qlik.com/t5/QlikView/What-is-the-error-in-this-set-expression/m-p/719836#M258535 2014-08-21T09:31:55Z Re: What is the error in this set expression? https://community.qlik.com/t5/QlikView/What-is-the-error-in-this-set-expression/m-p/719837#M258536 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P>=if(sum( distinct EmployeeBucket )<STRONG>&gt;90</STRONG> and sum(distinct EmployeeBucket )<STRONG>&lt;=100</STRONG>,Count( DISTINCT [Employee Number])) </P></BODY></HTML> Thu, 21 Aug 2014 09:35:20 GMT https://community.qlik.com/t5/QlikView/What-is-the-error-in-this-set-expression/m-p/719837#M258536 tresB 2014-08-21T09:35:20Z Re: What is the error in this set expression? https://community.qlik.com/t5/QlikView/What-is-the-error-in-this-set-expression/m-p/719838#M258537 <HTML><HEAD></HEAD><BODY><P><BR />Hello,</P><P></P><P>Please check your condition sum( distinct EmployeeBucket) is returning values between 90 to 100, only then this condition should work</P><P></P><P>Regards,</P><P>Nita Prasad</P></BODY></HTML> Thu, 21 Aug 2014 09:36:00 GMT https://community.qlik.com/t5/QlikView/What-is-the-error-in-this-set-expression/m-p/719838#M258537 Anonymous 2014-08-21T09:36:00Z Re: What is the error in this set expression? https://community.qlik.com/t5/QlikView/What-is-the-error-in-this-set-expression/m-p/719839#M258538 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>What values are there in EmployeeBucket??</P><P></P><P>Regards</P></BODY></HTML> Thu, 21 Aug 2014 09:41:24 GMT https://community.qlik.com/t5/QlikView/What-is-the-error-in-this-set-expression/m-p/719839#M258538 PrashantSangle 2014-08-21T09:41:24Z Re: What is the error in this set expression? https://community.qlik.com/t5/QlikView/What-is-the-error-in-this-set-expression/m-p/719840#M258539 <HTML><HEAD></HEAD><BODY><P>Hi TheVIlla,</P><P></P><P>=Count(DISTINCT{$&lt;EmployeeBucket={'&gt;90 &lt;=100'}&gt;}EmployeeBucket)</P><P>use this expression in text object may gives the result.</P></BODY></HTML> Thu, 21 Aug 2014 10:03:19 GMT https://community.qlik.com/t5/QlikView/What-is-the-error-in-this-set-expression/m-p/719840#M258539 2014-08-21T10:03:19Z