Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

counting active employee less than selected year

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

4 Replies
Not applicable

Re: counting active employee less than selected year

send some data sample (qvw )

Re: counting active employee less than selected year

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

Not applicable

Re: counting active employee less than selected year

hi

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

Not applicable

Re: counting active employee less than selected year

hi

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

Community Browser