Last Year Formula

qlikviewaf — Sat, 16 Nov 2024 20:56:43 GMT

Hi,

i have this formula working well, giving me the sum of Amount for the current year - which is sum from first of january till today.

I would like to have the same formula but for the prior year (2018) based on the maximum invoice date number of this year (2019). i tried to set it up, the one below but is not working.

Anyone can help?

Formula 2018 not working: should extract Amount from the first of january 2018 till today of 1 year ago

=Sum({<Invoice_Date_Num={">=$(=Num(YearStart(Max(Invoice_Date_Num), -1)))<=$(=Num(AddYears(Max(Invoice_Date_Num), -1)))"}>}Amount)

Formula 2019 working well

=Sum({<Invoice_Date_Num={">=$(=Num(YearStart(Max(Invoice_Date_Num))))<=$(=Max(Invoice_Date_Num))"}>}Amount)

Re: Last Year Formula

Claudiu_Anghelescu — Fri, 03 May 2019 11:39:34 GMT

Try to define a variable for PY and use the variable in the Expresion Analysis.

topic Re: Last Year Formula in QlikView

Last Year Formula

Re: Last Year Formula