Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
tmumaw
Valued Contributor

Date Calculation

Hi All, Need a little help with an expression.  I'm trying to count the number of active employees between a date range using set analysis.  I have 2 variables the user can select from on a screen.  First on is a valid from and the next one is a valid to.  From some reason just can't figure it out.  Thanks

 

Here is what I have so far:

Count({<Num_Date_ZWKDATE = {"=> $(vStartDate)"} & {"<= $(vEndDate)"}>}Distinct ActiveEmpID)

Labels (2)
1 Solution

Accepted Solutions
bharathadde
Contributor II

Re: Date Calculation

Try this

=Count(Distinct {<Num_Date_ZWKDATE = {'>= $(=vStartDate)<= $(=vEndDate)'}>} ActiveEmpID)

1 Reply
bharathadde
Contributor II

Re: Date Calculation

Try this

=Count(Distinct {<Num_Date_ZWKDATE = {'>= $(=vStartDate)<= $(=vEndDate)'}>} ActiveEmpID)