Show data for last 2 years in pivot by week qliksense

[Aspiring_Developer]

Hi All,

I have below table :-

Dimensin - LOB | New_year_Trend| Week

Measure - sum({<LOGGED_DATE_New=,test=,ISSUE_CLOSED_DATE=, Date_key=,Year_NEW_Trend={$(=Max(Year_NEW_Trend)),$(=Max(Year_NEW_Trend)-1)}>} TREND_VOL)

I am showcasing weekly data for last 2 years using set analysis. However, in the backend I have data commencing frpom 2020  till 2021 and the dimension Year_new_Trend in the above table is used as a filter. I wish to show this year filter with only 2 years of values i/e 2021 and 2022 . Right now It is showing like this :-

Also this year field is coming from master calendar

How can I achieve it ? 

Thanks in advance

[brunobertels]

Hi 

may be this :

if(Year_NEW_Trend>year(today())-2,Year_NEW_Trend)