Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

Highlighted

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