Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi @Bluedot24
Try like below
Sum({<Date={">=$(=MonthStart(YearEnd(Max(Date),-1)))<=$(=MonthEnd(YearEnd(Max(Date),-1)))"}, Year=, Month=, Quarter=>}Sales)
Hi @Bluedot24
Try like below
Sum({<Date={">=$(=MonthStart(YearEnd(Max(Date),-1)))<=$(=MonthEnd(YearEnd(Max(Date),-1)))"}, Year=, Month=, Quarter=>}Sales)