topic Deriving the Quarters in QlikView https://community.qlik.com/t5/QlikView/Deriving-the-Quarters/m-p/703149#M253666 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have a Calendar i.e July-June and i need to derive Quarters like this:</P><P>July-Sep = Q1</P><P>Oct-Dec= Q2</P><P>Jan-Mar=Q3</P><P>Apr-June=Q4</P><P></P><P>I Have a column for Month, by using this how to derive Quarters?</P></BODY></HTML> Tue, 19 Aug 2014 10:09:05 GMT Anonymous 2014-08-19T10:09:05Z Deriving the Quarters https://community.qlik.com/t5/QlikView/Deriving-the-Quarters/m-p/703149#M253666 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have a Calendar i.e July-June and i need to derive Quarters like this:</P><P>July-Sep = Q1</P><P>Oct-Dec= Q2</P><P>Jan-Mar=Q3</P><P>Apr-June=Q4</P><P></P><P>I Have a column for Month, by using this how to derive Quarters?</P></BODY></HTML> Tue, 19 Aug 2014 10:09:05 GMT https://community.qlik.com/t5/QlikView/Deriving-the-Quarters/m-p/703149#M253666 Anonymous 2014-08-19T10:09:05Z Re: Deriving the Quarters https://community.qlik.com/t5/QlikView/Deriving-the-Quarters/m-p/703150#M253667 <HTML><HEAD></HEAD><BODY><P>'Q' &amp; ceil(match(Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')/3)</P></BODY></HTML> Tue, 19 Aug 2014 10:13:33 GMT https://community.qlik.com/t5/QlikView/Deriving-the-Quarters/m-p/703150#M253667 Gysbert_Wassenaar 2014-08-19T10:13:33Z Re: Deriving the Quarters https://community.qlik.com/t5/QlikView/Deriving-the-Quarters/m-p/703151#M253668 <HTML><HEAD></HEAD><BODY><P>If you have the Date field then just use month start() or just nested iff as </P><P><STRONG>If(wildmatch('July','Aug','Sept',Month),'Q1'--</STRONG></P></BODY></HTML> Tue, 19 Aug 2014 10:17:14 GMT https://community.qlik.com/t5/QlikView/Deriving-the-Quarters/m-p/703151#M253668 sujeetsingh 2014-08-19T10:17:14Z Re: Deriving the Quarters https://community.qlik.com/t5/QlikView/Deriving-the-Quarters/m-p/703152#M253669 <HTML><HEAD></HEAD><BODY><P>This can also work</P><P>'Q' &amp; ceil(month/3)</P></BODY></HTML> Tue, 19 Aug 2014 10:18:47 GMT https://community.qlik.com/t5/QlikView/Deriving-the-Quarters/m-p/703152#M253669 sujeetsingh 2014-08-19T10:18:47Z