Dynamic way of geting the year data

[SRI8273]

in qlik sense when we are dealing with historical data i want to write a condition so that we can load the last 3 year of data dynamically if a new year also came

[maxgro]

try with 

YEAR(now(1))-2

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFunc...

[maxgro]

or, for the last 3 years

Date(AddMonths(floor(now(1)),-36))