How to get LYTD

[raZor]

Hi Qlikers,

I want set expression for sum of sales with dates from starting of last year till end of last year last month.

So, if today is 12/07/2024

I want sum of sales from 01/01/2023-30/06/2023 since we are in between of current month.

Set expression please.

Regards,

[poklegoguy]

Pretty sure there's a cleaner way but this will work

{$<sales_date={">=$(=YearStart(Today(),-1))<=$(=MonthEnd(AddYears(Today(),-1),-1))"}>}

[TauseefKhan]

Hi @raZor ,

Check with this:
Sum({<DateField = {">=$(=YearStart(AddYears(Today(), -1)))<=$(=MonthEnd(AddMonths(YearStart(AddYears(Today(), -1)), Month(Today())-2)))"}>} Sales)