topic Re: How to derive Fiscal Quarter? in QlikView https://community.qlik.com/t5/QlikView/How-to-derive-Fiscal-Quarter/m-p/57073#M9499 <HTML><HEAD></HEAD><BODY><P>If your month is not a dual field, you might try like:</P><P></P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Ceil(If(Month&gt;10, Month-10,&nbsp; Month+2)/3) as QuarterNum;</P><P>Load </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Month(Date#(Month,'MMM')) as Month</STRONG>&nbsp; Inline [</P><P> Month</P><P>Jan</P><P>Feb</P><P>Mar</P><P>Apr</P><P>May</P><P>Jun</P><P>Jul</P><P>Aug</P><P>Sep</P><P>Oct</P><P>Nov</P><P>Dec]</P></BODY></HTML> Thu, 05 Apr 2018 07:19:26 GMT tresB 2018-04-05T07:19:26Z How to derive Fiscal Quarter? https://community.qlik.com/t5/QlikView/How-to-derive-Fiscal-Quarter/m-p/57070#M9496 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have Months and want to derive Fiscal Quarters.</P><P>How to derive the Quarter based on Month while my year starts with Nov?</P><P></P><P>&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 168px;"><TBODY><TR><TD class="xl66" height="24" width="84">Month</TD><TD class="xl66" width="84">Qtr</TD></TR><TR><TD class="xl67" height="24" width="84">Nov</TD><TD align="right" class="xl66">1</TD></TR><TR><TD class="xl67" height="20" width="84">Dec</TD><TD align="right" class="xl66">1</TD></TR><TR><TD class="xl67" height="34" width="84">Jan</TD><TD align="right" class="xl66">1</TD></TR><TR><TD class="xl67" height="20" width="84">Feb</TD><TD align="right" class="xl66">2</TD></TR><TR><TD class="xl67" height="20" width="84">Mar</TD><TD align="right" class="xl66">2</TD></TR><TR><TD class="xl67" height="20" width="84">Apr</TD><TD align="right" class="xl66">2</TD></TR><TR><TD class="xl67" height="21" width="84">May</TD><TD align="right" class="xl66">3</TD></TR><TR><TD class="xl67" height="20" width="84">Jun</TD><TD align="right" class="xl66">3</TD></TR><TR><TD class="xl67" height="20" width="84">Jul</TD><TD align="right" class="xl66">3</TD></TR><TR><TD class="xl67" height="21" width="84">Aug</TD><TD align="right" class="xl66">4</TD></TR><TR><TD class="xl67" height="20" width="84">Sep</TD><TD align="right" class="xl66">4</TD></TR><TR><TD class="xl67" height="20" width="84">Oct</TD><TD align="right" class="xl66"><P>4</P></TD></TR></TBODY></TABLE><P></P><P>Regards,</P><P>Satya</P></BODY></HTML> Thu, 05 Apr 2018 06:57:54 GMT https://community.qlik.com/t5/QlikView/How-to-derive-Fiscal-Quarter/m-p/57070#M9496 narayanamsn 2018-04-05T06:57:54Z Re: How to derive Fiscal Quarter? https://community.qlik.com/t5/QlikView/How-to-derive-Fiscal-Quarter/m-p/57071#M9497 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>might be this thread help you</P><P><A href="https://community.qlik.com/thread/296601">Creating Qtr View in Cross table</A></P><P></P><P>Regards,</P></BODY></HTML> Thu, 05 Apr 2018 07:12:34 GMT https://community.qlik.com/t5/QlikView/How-to-derive-Fiscal-Quarter/m-p/57071#M9497 PrashantSangle 2018-04-05T07:12:34Z Re: How to derive Fiscal Quarter? https://community.qlik.com/t5/QlikView/How-to-derive-Fiscal-Quarter/m-p/57072#M9498 <HTML><HEAD></HEAD><BODY><P>Try like:</P><P></P><P>Ceil(If(Month&gt;10, Month-10,&nbsp; Month+2)/3) as QuarterNum;</P></BODY></HTML> Thu, 05 Apr 2018 07:13:13 GMT https://community.qlik.com/t5/QlikView/How-to-derive-Fiscal-Quarter/m-p/57072#M9498 tresB 2018-04-05T07:13:13Z Re: How to derive Fiscal Quarter? https://community.qlik.com/t5/QlikView/How-to-derive-Fiscal-Quarter/m-p/57073#M9499 <HTML><HEAD></HEAD><BODY><P>If your month is not a dual field, you might try like:</P><P></P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Ceil(If(Month&gt;10, Month-10,&nbsp; Month+2)/3) as QuarterNum;</P><P>Load </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Month(Date#(Month,'MMM')) as Month</STRONG>&nbsp; Inline [</P><P> Month</P><P>Jan</P><P>Feb</P><P>Mar</P><P>Apr</P><P>May</P><P>Jun</P><P>Jul</P><P>Aug</P><P>Sep</P><P>Oct</P><P>Nov</P><P>Dec]</P></BODY></HTML> Thu, 05 Apr 2018 07:19:26 GMT https://community.qlik.com/t5/QlikView/How-to-derive-Fiscal-Quarter/m-p/57073#M9499 tresB 2018-04-05T07:19:26Z