https://community.qlik.com/t5/QlikView/Count-in-set-analysis/m-p/1795844#M1211197 <P>from what I can see, the issue is that the Count(distinct OrgCode) is always 1, so this condition is never met, as well it will not give any OrgCodes either as they are all strings, not numbers.</P> Wed, 31 Mar 2021 02:54:38 GMT Lisa_P 2021-03-31T02:54:38Z https://community.qlik.com/t5/QlikView/Count-in-set-analysis/m-p/1795841#M1211195 <P>Hi Community,</P><P>can you please correct me below expression, not giving any value..</P><P>same expression have written script level working fine, but in set analysis not giving any value</P><P>=AVG(AGGR(AVG({$&lt;OrgCode= {"=Count(DISTINCT OrgCode)&gt;2"}&gt;}BASE_SALARY), SURVEY, MUPC_CODE, Industry))</P><P>&nbsp;</P><P>Thanks in Advance</P> Wed, 31 Mar 2021 01:35:19 GMT https://community.qlik.com/t5/QlikView/Count-in-set-analysis/m-p/1795841#M1211195 paulwalker 2021-03-31T01:35:19Z https://community.qlik.com/t5/QlikView/Count-in-set-analysis/m-p/1795844#M1211197 <P>from what I can see, the issue is that the Count(distinct OrgCode) is always 1, so this condition is never met, as well it will not give any OrgCodes either as they are all strings, not numbers.</P> Wed, 31 Mar 2021 02:54:38 GMT https://community.qlik.com/t5/QlikView/Count-in-set-analysis/m-p/1795844#M1211197 Lisa_P 2021-03-31T02:54:38Z