topic AW:Set Analysis Expression in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Expression/m-p/224971#M77328 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>try this:</P><P>Count({&lt;([Part of Headcount]={'Yes'},[Start Date For Month] = {$(=CurrentMonth)}&gt;} Distinct [Emp ID])</P></BODY></HTML> Tue, 22 Feb 2011 12:32:34 GMT brenner_martina 2011-02-22T12:32:34Z Set Analysis Expression https://community.qlik.com/t5/QlikView/Set-Analysis-Expression/m-p/224970#M77327 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>If anybody could tell me an equivalent Set Analysis expression for the below</P><P>Count(Distinct If([Part of Headcount]='Yes' and [Start Date For Month] = CurrentMonth,[Emp ID]))</P><P>Note that the [Start Date For Month] &amp; CurrentMonth are dates.</P><P>Please help.</P><P>Thanks in advance.</P><P>Amar</P></BODY></HTML> Tue, 22 Feb 2011 12:23:18 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Expression/m-p/224970#M77327 amars 2011-02-22T12:23:18Z AW:Set Analysis Expression https://community.qlik.com/t5/QlikView/Set-Analysis-Expression/m-p/224971#M77328 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>try this:</P><P>Count({&lt;([Part of Headcount]={'Yes'},[Start Date For Month] = {$(=CurrentMonth)}&gt;} Distinct [Emp ID])</P></BODY></HTML> Tue, 22 Feb 2011 12:32:34 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Expression/m-p/224971#M77328 brenner_martina 2011-02-22T12:32:34Z