How to Create the measure for rolling 12 months based on another date field

[RajeevaM061]

Hello, 

Could you please help me  the set expression on how to create the measure for the Rolling 12 months based on the another data field. 

For Example :  The Rolling 12 months range should be calculated based on the Product End date in the below example. This date is different for the each customer and contract ID. 

#Qliksense 

Customer	Product	Contract ID	Product End Date	Rolling 12 months - Sales ( Range based on Product End Date)
Cus1	P1	C123	Jan-22	$Net Sales for the Range Jan 2022 -Feb2021
Cus1	P1	C234	Feb-22	$Net Sales for the Range Feb 2022 -March 2021
Cus1	P1	C569	Mar-22	$Net Sales for the Range Mar 2022 -april 2021

[edwin]

you may want to take a look at this, your table could be an associating between your product end date field to all the transactions bounded by the 12-month period.

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130