Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
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 (3)
1 Reply

Hi AFernandes,

Use the below expression .

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

Hope it works for you,