Quarter Previous Year

[qlikviewaf]

Hi,

i would like to calculate the FULL quarter value of last year ( i already read the other topics ).

I created this formula, the user is supposed to select year - month - day. The "Invoice_date_num" is the key field with my calendar.

I used Quarterstart and QuarterEnd +  addyeras but the formula is not working properly (i got inconsistent value)

Where is the error?

Sum({<Year=, Month=, Quarter=, Week=, Day=,Invoice_Date=, Invoice_Date_Num={">=$(=Num(QuarterStart(addyears(Max(Invoice_Date_Num),-1))))<=$(=Num(QuarterEnd(addyears(Max(Invoice_Date_Num),-1))))"}>} ExtendedUSD))

[sunny_talwar]

Is this a typo, or do you have an extra parenthesis at the end?