Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Afernandes
Contributor II
Contributor II

Count Before a date

Good morning everyone

I have one more question.
I'm trying to count the number of people who have worked in a company for over 3 years. I have a field that is date of admission and the field P_ID(the workers). Strangely I know how to do with specific intervals of time, but I do not know how to do it until 3 years ago.

Thank you very much

Labels (2)
1 Reply
Kashyap_R
Partner - Specialist
Partner - Specialist

Hi AFernandes,

Use the below expression .

=Sum(If((Today() - [Joined Date.autoCalendar.Date])>1094,1,0))

Hope it works for you,

Thanks,

Thanks and Regards
Kashyap.R