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

how to write condition to get Weekly Hires

I have Hire Date and i have Date Extracted from my table. I need to know how many Hires i have in a week, as my data gets refreshed every week.

what should be the If condition statement for this. how to find out weekly hires from data.

for example.

Thanks!

2 Replies
sunny_talwar

May be create a straight table with WeekYear_HireDate as Dimension and Count(DISTINCT EmployeeID) as the expression?

ramasaisaksoft

Hi Srikant,

you need to create a field like this in Script  week(DateId) as Week

=if(week=Max(week), count(Hires))

it will solve ur issue for Current week