Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

hi

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

Not applicable
Author

hi

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