https://community.qlik.com/t5/QlikView/QuarterStart-and-QuarterName-Help/m-p/1655548#M729470 <P>Hi,&nbsp; Im using the following to work out which Quarter a date falls in by using :</P><P>QuarterName([End Date])&nbsp;&nbsp;</P><P>&nbsp;</P><P>We need to change this so that instead of the Quarters running from Apr - Mar they run from Mar to Feb so this month (December) falls in Quarter 4 (Dec-Jan-Feb) rather than Q3.</P><P>Can anyone advise on this please?</P><P>&nbsp;</P><P>Thanks&nbsp;</P><P>&nbsp;</P><P>Phil</P> Wed, 25 Nov 2020 16:16:04 GMT prees959 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/QuarterStart-and-QuarterName-Help/m-p/1655548#M729470 <P>Hi,&nbsp; Im using the following to work out which Quarter a date falls in by using :</P><P>QuarterName([End Date])&nbsp;&nbsp;</P><P>&nbsp;</P><P>We need to change this so that instead of the Quarters running from Apr - Mar they run from Mar to Feb so this month (December) falls in Quarter 4 (Dec-Jan-Feb) rather than Q3.</P><P>Can anyone advise on this please?</P><P>&nbsp;</P><P>Thanks&nbsp;</P><P>&nbsp;</P><P>Phil</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/QuarterStart-and-QuarterName-Help/m-p/1655548#M729470 prees959 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/QuarterStart-and-QuarterName-Help/m-p/1657358#M729471 <P>Try this:</P><P>QuarterName(<STRONG><EM>&lt;Date&gt;</EM></STRONG>,0,3)</P><P>QuarterStart(<EM><STRONG>&lt;Date&gt;</STRONG></EM>,0,3)</P><P>Replace&nbsp;<EM><STRONG>&lt;Date&gt;&nbsp;</STRONG></EM> with your Date column.</P><P>&nbsp;</P> Fri, 13 Dec 2019 01:54:27 GMT https://community.qlik.com/t5/QlikView/QuarterStart-and-QuarterName-Help/m-p/1657358#M729471 Arthur_Fong 2019-12-13T01:54:27Z