https://community.qlik.com/t5/App-Development/Count-Before-a-date/m-p/1597976#M44207 <P>Good morning everyone</P><P>I have one more question.<BR />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.<BR /><BR />Thank you very much</P> Sat, 16 Nov 2024 20:32:28 GMT Afernandes 2024-11-16T20:32:28Z https://community.qlik.com/t5/App-Development/Count-Before-a-date/m-p/1597976#M44207 <P>Good morning everyone</P><P>I have one more question.<BR />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.<BR /><BR />Thank you very much</P> Sat, 16 Nov 2024 20:32:28 GMT https://community.qlik.com/t5/App-Development/Count-Before-a-date/m-p/1597976#M44207 Afernandes 2024-11-16T20:32:28Z https://community.qlik.com/t5/App-Development/Count-Before-a-date/m-p/1624033#M46471 <P>Hi AFernandes,</P><P>Use the below expression .</P><P><STRONG>=Sum(If((Today() - [Joined Date.autoCalendar.Date])&gt;1094,1,0))</STRONG></P><P>Hope it works for you,</P><P>Thanks,</P> Mon, 16 Sep 2019 07:37:17 GMT https://community.qlik.com/t5/App-Development/Count-Before-a-date/m-p/1624033#M46471 Kashyap_R 2019-09-16T07:37:17Z