topic Date Range to Summarize by Quarter in QlikView https://community.qlik.com/t5/QlikView/Date-Range-to-Summarize-by-Quarter/m-p/1107831#M462707 <HTML><HEAD></HEAD><BODY><P>How do I create an expression to take the date column and break it up by quarters. For example 1/1/2016 to 3/31/2016 = 2016Q1</P><P></P><P>Thank you!</P></BODY></HTML> Mon, 29 Aug 2016 18:11:46 GMT 2016-08-29T18:11:46Z Date Range to Summarize by Quarter https://community.qlik.com/t5/QlikView/Date-Range-to-Summarize-by-Quarter/m-p/1107831#M462707 <HTML><HEAD></HEAD><BODY><P>How do I create an expression to take the date column and break it up by quarters. For example 1/1/2016 to 3/31/2016 = 2016Q1</P><P></P><P>Thank you!</P></BODY></HTML> Mon, 29 Aug 2016 18:11:46 GMT https://community.qlik.com/t5/QlikView/Date-Range-to-Summarize-by-Quarter/m-p/1107831#M462707 2016-08-29T18:11:46Z Re: Date Range to Summarize by Quarter https://community.qlik.com/t5/QlikView/Date-Range-to-Summarize-by-Quarter/m-p/1107832#M462708 <HTML><HEAD></HEAD><BODY><P>May be create it in your master calendar script:</P><P></P><P><A href="https://community.qlik.com/thread/48693">Creating A Master Calendar</A>‌</P><P></P><P><STRONG>LOAD Date,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Year,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Month,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Year&amp;'Q'&amp;Ceil(Month(DateField)/3) as YearQuarter</STRONG></P></BODY></HTML> Mon, 29 Aug 2016 18:48:54 GMT https://community.qlik.com/t5/QlikView/Date-Range-to-Summarize-by-Quarter/m-p/1107832#M462708 sunny_talwar 2016-08-29T18:48:54Z