topic How to count Rookies number in the company in QlikView https://community.qlik.com/t5/QlikView/How-to-count-Rookies-number-in-the-company/m-p/79987#M13166 <HTML><HEAD></HEAD><BODY><P>Hello everyone ,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have to count the total number of rokkies in the company so i have these data:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">1- count({&lt;PERSON_TYPE_ID={6}&gt;}distinct PERSON_ID) .&nbsp; (These for count Total employees)</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">2-&nbsp; I should subtract from Current Date -2 </P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">3- I should subtract Current date from Date Start&nbsp; if the result &gt;=2 then count it as rookies</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">DateStart-Current date &gt;=2 ,Count ({&lt;PERSON_TYPE_ID={6}&gt;}distinct PERSON_ID)</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">How can I solve it&nbsp; could you please help me!<SPAN class="emoticon-inline emoticon_sad" style="font-weight: inherit; font-style: inherit; font-family: inherit;"></SPAN><SPAN class="emoticon-inline emoticon_cry" style="font-weight: inherit; font-style: inherit; font-family: inherit;"></SPAN></P></BODY></HTML> Sat, 09 Jun 2018 20:00:28 GMT Anonymous 2018-06-09T20:00:28Z How to count Rookies number in the company https://community.qlik.com/t5/QlikView/How-to-count-Rookies-number-in-the-company/m-p/79987#M13166 <HTML><HEAD></HEAD><BODY><P>Hello everyone ,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have to count the total number of rokkies in the company so i have these data:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">1- count({&lt;PERSON_TYPE_ID={6}&gt;}distinct PERSON_ID) .&nbsp; (These for count Total employees)</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">2-&nbsp; I should subtract from Current Date -2 </P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">3- I should subtract Current date from Date Start&nbsp; if the result &gt;=2 then count it as rookies</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">DateStart-Current date &gt;=2 ,Count ({&lt;PERSON_TYPE_ID={6}&gt;}distinct PERSON_ID)</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">How can I solve it&nbsp; could you please help me!<SPAN class="emoticon-inline emoticon_sad" style="font-weight: inherit; font-style: inherit; font-family: inherit;"></SPAN><SPAN class="emoticon-inline emoticon_cry" style="font-weight: inherit; font-style: inherit; font-family: inherit;"></SPAN></P></BODY></HTML> Sat, 09 Jun 2018 20:00:28 GMT https://community.qlik.com/t5/QlikView/How-to-count-Rookies-number-in-the-company/m-p/79987#M13166 Anonymous 2018-06-09T20:00:28Z Re: How to count Rookies number in the company https://community.qlik.com/t5/QlikView/How-to-count-Rookies-number-in-the-company/m-p/79988#M13167 <HTML><HEAD></HEAD><BODY><P>Can you elaborate the issue you are facing and what is your actual expression you are trying can you post here? Is yoru DateStart and CurrentDate in same format? </P></BODY></HTML> Mon, 23 Jul 2018 16:11:51 GMT https://community.qlik.com/t5/QlikView/How-to-count-Rookies-number-in-the-company/m-p/79988#M13167 vishsaggi 2018-07-23T16:11:51Z