topic Issue with Quarter! in QlikView https://community.qlik.com/t5/QlikView/Issue-with-Quarter/m-p/183607#M48796 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I am using the below function to retrieve the quarter but my clients financial year starts from april but where us here when i click on Q1 it selects jan - mar. I want that to select apr-jun and so on. Let me know how it can be done!</P><P>I know the solution may be to load the quarter using the inline function. I want know some other solution which can solve this problem.</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />'Q' &amp; Ceil(Month(DATE)/3) as Quarter<BR /></PRE><BR /><BR /> <P>Thanks and Regards,</P><P>Rikab</P></BODY></HTML> Wed, 17 Mar 2010 12:56:09 GMT 2010-03-17T12:56:09Z Issue with Quarter! https://community.qlik.com/t5/QlikView/Issue-with-Quarter/m-p/183607#M48796 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I am using the below function to retrieve the quarter but my clients financial year starts from april but where us here when i click on Q1 it selects jan - mar. I want that to select apr-jun and so on. Let me know how it can be done!</P><P>I know the solution may be to load the quarter using the inline function. I want know some other solution which can solve this problem.</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />'Q' &amp; Ceil(Month(DATE)/3) as Quarter<BR /></PRE><BR /><BR /> <P>Thanks and Regards,</P><P>Rikab</P></BODY></HTML> Wed, 17 Mar 2010 12:56:09 GMT https://community.qlik.com/t5/QlikView/Issue-with-Quarter/m-p/183607#M48796 2010-03-17T12:56:09Z Issue with Quarter! https://community.qlik.com/t5/QlikView/Issue-with-Quarter/m-p/183608#M48797 <HTML><HEAD></HEAD><BODY><P>Hi Rikab</P><P>If you subtract 3 months from the given date it should work:</P><P>'Q' &amp; Ceil(Month(addmonths(DATE,-3))/3) as Quarter</P><P></P><P>regards<BR />/Fredrik</P></BODY></HTML> Wed, 17 Mar 2010 13:04:04 GMT https://community.qlik.com/t5/QlikView/Issue-with-Quarter/m-p/183608#M48797 2010-03-17T13:04:04Z