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: 
Anonymous
Not applicable

How to count Rookies number in the company

Hello everyone ,

I have to count the total number of rokkies in the company so i have these data:

1- count({<PERSON_TYPE_ID={6}>}distinct PERSON_ID) .  (These for count Total employees)

2-  I should subtract from Current Date -2

3- I should subtract Current date from Date Start  if the result >=2 then count it as rookies

DateStart-Current date >=2 ,Count ({<PERSON_TYPE_ID={6}>}distinct PERSON_ID)

How can I solve it  could you please help me!

1 Reply
vishsaggi
Champion III
Champion III

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?