topic Re: Quarter Previous Year in QlikView https://community.qlik.com/t5/QlikView/Quarter-Previous-Year/m-p/1383460#M421410 <HTML><HEAD></HEAD><BODY><P>Is this a typo, or do you have an extra parenthesis at the end?</P></BODY></HTML> Wed, 20 Sep 2017 14:40:27 GMT sunny_talwar 2017-09-20T14:40:27Z Quarter Previous Year https://community.qlik.com/t5/QlikView/Quarter-Previous-Year/m-p/1383459#M421409 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i would like to calculate the FULL quarter value of last year ( i already read the other topics ).</P><P></P><P>I created this formula, the user is supposed to select year - month - day. The "Invoice_date_num" is the key field with my calendar.</P><P>I used Quarterstart and QuarterEnd +&nbsp; addyeras but the formula is not working properly (i got inconsistent value)</P><P>Where is the error?</P><P></P><P>Sum({&lt;Year=, Month=, Quarter=, Week=, Day=,Invoice_Date=, Invoice_Date_Num={"&gt;=$(=Num(QuarterStart(addyears(Max(Invoice_Date_Num),-1))))&lt;=$(=Num(QuarterEnd(addyears(Max(Invoice_Date_Num),-1))))"}&gt;} ExtendedUSD))</P></BODY></HTML> Wed, 20 Sep 2017 14:35:40 GMT https://community.qlik.com/t5/QlikView/Quarter-Previous-Year/m-p/1383459#M421409 qlikviewaf 2017-09-20T14:35:40Z Re: Quarter Previous Year https://community.qlik.com/t5/QlikView/Quarter-Previous-Year/m-p/1383460#M421410 <HTML><HEAD></HEAD><BODY><P>Is this a typo, or do you have an extra parenthesis at the end?</P></BODY></HTML> Wed, 20 Sep 2017 14:40:27 GMT https://community.qlik.com/t5/QlikView/Quarter-Previous-Year/m-p/1383460#M421410 sunny_talwar 2017-09-20T14:40:27Z