https://community.qlik.com/t5/QlikView/Date-Calculation/m-p/1588328#M443350 <P>Hi All, Need a little help with an expression.&nbsp; I'm trying to count the number of active employees between a date range using set analysis.&nbsp; I have 2 variables the user can select from on a screen.&nbsp; First on is a valid from and the next one is a valid to.&nbsp; From some reason just can't figure it out.&nbsp; Thanks</P><P>&nbsp;</P><P>Here is what I have so far:</P><P>Count({&lt;Num_Date_ZWKDATE = {"=&gt; $(vStartDate)"} &amp; {"&lt;= $(vEndDate)"}&gt;}Distinct ActiveEmpID)</P> Sat, 16 Nov 2024 03:23:31 GMT tmumaw 2024-11-16T03:23:31Z https://community.qlik.com/t5/QlikView/Date-Calculation/m-p/1588328#M443350 <P>Hi All, Need a little help with an expression.&nbsp; I'm trying to count the number of active employees between a date range using set analysis.&nbsp; I have 2 variables the user can select from on a screen.&nbsp; First on is a valid from and the next one is a valid to.&nbsp; From some reason just can't figure it out.&nbsp; Thanks</P><P>&nbsp;</P><P>Here is what I have so far:</P><P>Count({&lt;Num_Date_ZWKDATE = {"=&gt; $(vStartDate)"} &amp; {"&lt;= $(vEndDate)"}&gt;}Distinct ActiveEmpID)</P> Sat, 16 Nov 2024 03:23:31 GMT https://community.qlik.com/t5/QlikView/Date-Calculation/m-p/1588328#M443350 tmumaw 2024-11-16T03:23:31Z https://community.qlik.com/t5/QlikView/Date-Calculation/m-p/1588330#M443351 <P>Try this</P><P><SPAN>=Count(Distinct {&lt;Num_Date_ZWKDATE = {'&gt;= $(=vStartDate)&lt;= $(=vEndDate)'}&gt;} ActiveEmpID)</SPAN></P> Tue, 04 Jun 2019 19:01:02 GMT https://community.qlik.com/t5/QlikView/Date-Calculation/m-p/1588330#M443351 bharathadde 2019-06-04T19:01:02Z