Discussion board where members can get started with QlikView.
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.
May be create a straight table with WeekYear_HireDate as Dimension and Count(DISTINCT EmployeeID) as the expression?
you need to create a field like this in Script week(DateId) as Week
it will solve ur issue for Current week