topic Re: Compare Quarters in QlikView https://community.qlik.com/t5/QlikView/Compare-Quarters/m-p/1277239#M864225 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply Maxgro, I will give it a try.</P></BODY></HTML> Sat, 17 Dec 2016 17:03:27 GMT 2016-12-17T17:03:27Z Compare Quarters https://community.qlik.com/t5/QlikView/Compare-Quarters/m-p/1277237#M864223 <HTML><HEAD></HEAD><BODY><P>I am using this formula to extract the quarters from my date field.</P><P></P><P></P><P>= 'Q' &amp; Ceil(Month([Create Date])/3) &amp; '-' &amp; Year([Create Date])</P><P></P><P>From this I get Q1-2016, Q2-2016, Q3-2016, Q4-2016. What I am having an issue putting together, a text field with the % change of:</P><P></P><P>Q3-2016 vs Q4-2016</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Compare-Quarters/m-p/1277237#M864223 2020-11-25T16:16:04Z Re: Compare Quarters https://community.qlik.com/t5/QlikView/Compare-Quarters/m-p/1277238#M864224 <HTML><HEAD></HEAD><BODY><P>I think with quarter serial field in a calendar (create the calendar in the script)</P><P>Look at Gysbert's answer here </P><P><A href="https://community.qlik.com/message/443947">Re: Week to week and quarter to quarter comparison</A></P></BODY></HTML> Sat, 17 Dec 2016 14:41:05 GMT https://community.qlik.com/t5/QlikView/Compare-Quarters/m-p/1277238#M864224 maxgro 2016-12-17T14:41:05Z Re: Compare Quarters https://community.qlik.com/t5/QlikView/Compare-Quarters/m-p/1277239#M864225 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply Maxgro, I will give it a try.</P></BODY></HTML> Sat, 17 Dec 2016 17:03:27 GMT https://community.qlik.com/t5/QlikView/Compare-Quarters/m-p/1277239#M864225 2016-12-17T17:03:27Z