topic Quarter day number in QlikView https://community.qlik.com/t5/QlikView/Quarter-day-number/m-p/654909#M1072665 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need to create a field which will present quarter day number.</P><P>In each quarter we have 98 days.</P><P>so, for example, 1/1/2014 will be day 1, 2/1/2014 will be day 2, 1/7/2014 will be day 1, 2/7/2014 will be day 2.</P><P>So , how do I create it?</P><P></P><P>Thanks,</P></BODY></HTML> Mon, 11 Aug 2014 11:59:58 GMT 2014-08-11T11:59:58Z Quarter day number https://community.qlik.com/t5/QlikView/Quarter-day-number/m-p/654909#M1072665 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I need to create a field which will present quarter day number.</P><P>In each quarter we have 98 days.</P><P>so, for example, 1/1/2014 will be day 1, 2/1/2014 will be day 2, 1/7/2014 will be day 1, 2/7/2014 will be day 2.</P><P>So , how do I create it?</P><P></P><P>Thanks,</P></BODY></HTML> Mon, 11 Aug 2014 11:59:58 GMT https://community.qlik.com/t5/QlikView/Quarter-day-number/m-p/654909#M1072665 2014-08-11T11:59:58Z Re: Quarter day number https://community.qlik.com/t5/QlikView/Quarter-day-number/m-p/654910#M1072666 <HTML><HEAD></HEAD><BODY><P>The following expression would give you the QuarterDay field, if added in the MasterCalendar</P><P></P><P>date(TempDate) - QuarterStart(TempDate) + 1 AS QuarterDay</P><P></P><P>I hope this helps.</P><P>Agis</P></BODY></HTML> Mon, 11 Aug 2014 12:12:51 GMT https://community.qlik.com/t5/QlikView/Quarter-day-number/m-p/654910#M1072666 Agis-Kalogiannis 2014-08-11T12:12:51Z