https://community.qlik.com/t5/QlikView/Multiple-between-in-set-Analysis/m-p/1561798#M441348 <P>Dear All,</P><P>i didnot find the formula about multiple between in set Analysis, can any body help ? please...</P><P>"=Count(DISTINCT {&lt;EMPLOYEE_NO = {"=if(isnull(SCORE_MQ),0,Avg(SCORE_MQ)) &gt;= 80 and (Avg([A/T])&gt;=0.7&lt;0.9) and (Avg(BOBOT)&gt;=1.6 &lt;2.05)"}&gt;} EMPLOYEE_NO)"</P><P>the result in Yellow not match</P><P>Tq</P><P>Toni</P> Sat, 16 Nov 2024 21:10:11 GMT sutoniusahadong 2024-11-16T21:10:11Z https://community.qlik.com/t5/QlikView/Multiple-between-in-set-Analysis/m-p/1561798#M441348 <P>Dear All,</P><P>i didnot find the formula about multiple between in set Analysis, can any body help ? please...</P><P>"=Count(DISTINCT {&lt;EMPLOYEE_NO = {"=if(isnull(SCORE_MQ),0,Avg(SCORE_MQ)) &gt;= 80 and (Avg([A/T])&gt;=0.7&lt;0.9) and (Avg(BOBOT)&gt;=1.6 &lt;2.05)"}&gt;} EMPLOYEE_NO)"</P><P>the result in Yellow not match</P><P>Tq</P><P>Toni</P> Sat, 16 Nov 2024 21:10:11 GMT https://community.qlik.com/t5/QlikView/Multiple-between-in-set-Analysis/m-p/1561798#M441348 sutoniusahadong 2024-11-16T21:10:11Z https://community.qlik.com/t5/QlikView/Multiple-between-in-set-Analysis/m-p/1561847#M441354 <P>May be this</P><P><SPAN>=Count(DISTINCT {&lt;EMPLOYEE_NO = {"=Len(Trim(SCORE_MQ)) &gt; 0 and Avg(SCORE_MQ) &gt;= 80 and Avg([A/T]) &gt;= 0.7 and Avg([A/T]) &lt; 0.9 and Avg(BOBOT) &gt;= 1.6 and Avg(BOBOT) &lt; 2.05"}&gt;} EMPLOYEE_NO)</SPAN></P> Wed, 27 Mar 2019 11:38:01 GMT https://community.qlik.com/t5/QlikView/Multiple-between-in-set-Analysis/m-p/1561847#M441354 sunny_talwar 2019-03-27T11:38:01Z