How to get amount from last month (December) of prior year

[Bluedot24]

Hi,

I am new to Qlik Sense and am still finding my way around.

Can someone help me in figuring out how to get the amount from prior year December.

For e.g. If my current period = Feb 21

I would want to compare this value with Dec 20.

No matter what month is selected in 2021, I would always want to compare with Dec 20.

Thank you

[MayilVahanan · Accepted solution]

Hi @Bluedot24 

Try like below

Sum({<Date={">=$(=MonthStart(YearEnd(Max(Date),-1)))<=$(=MonthEnd(YearEnd(Max(Date),-1)))"}, Year=, Month=, Quarter=>}Sales)