topic how to write condition to get Weekly Hires in QlikView https://community.qlik.com/t5/QlikView/how-to-write-condition-to-get-Weekly-Hires/m-p/1036832#M921471 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>what should be the If condition statement for this. how to find out weekly hires from data.</P><P></P><P>for example.</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z how to write condition to get Weekly Hires https://community.qlik.com/t5/QlikView/how-to-write-condition-to-get-Weekly-Hires/m-p/1036832#M921471 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>what should be the If condition statement for this. how to find out weekly hires from data.</P><P></P><P>for example.</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-write-condition-to-get-Weekly-Hires/m-p/1036832#M921471 2020-11-25T16:16:04Z Re: how to write condition to get Weekly Hires https://community.qlik.com/t5/QlikView/how-to-write-condition-to-get-Weekly-Hires/m-p/1036833#M921472 <HTML><HEAD></HEAD><BODY><P>May be create a straight table with WeekYear_HireDate as Dimension and Count(DISTINCT EmployeeID) as the expression?</P></BODY></HTML> Thu, 28 Apr 2016 15:41:05 GMT https://community.qlik.com/t5/QlikView/how-to-write-condition-to-get-Weekly-Hires/m-p/1036833#M921472 sunny_talwar 2016-04-28T15:41:05Z Re: how to write condition to get Weekly Hires https://community.qlik.com/t5/QlikView/how-to-write-condition-to-get-Weekly-Hires/m-p/1036834#M921473 <HTML><HEAD></HEAD><BODY><P>Hi Srikant,</P><P></P><P>you need to create a field like this in Script&nbsp; week(DateId) as Week</P><P></P><P>=if(week=Max(week), count(Hires))</P><P></P><P>it will solve ur issue for Current week</P></BODY></HTML> Thu, 28 Apr 2016 15:58:01 GMT https://community.qlik.com/t5/QlikView/how-to-write-condition-to-get-Weekly-Hires/m-p/1036834#M921473 ramasaisaksoft 2016-04-28T15:58:01Z