counting active employee less than selected year

[#1]

Dear Experts,

                       i have to count all the active employee  from selected year till minimum year in the list.

guide me how i should do this i m new to qlikview.

Regards.

Tayyab

[#2]

send some data sample (qvw )

[MayilVahanan]

Hi,

     Try like this,

     =Count({<Year = {'>=$(=Min({1}Year)) <= $(=Max(Year))'}>}Distinct Employees)

     It gives count of distinct employees from selected year to minimum year in your list.

Hope it helps

[#4]

hi

if i want to use the same formula for the selected year ,month and day.

[#5]

hi

if i want to use the same formula for the selected year ,month and day.