Custom date range

[marcosirotti1950]

Hi, how can I define a date range in which the user select a date field as the end date and  the start date is calculated as End date - 90 days, using the date picker or some kind of filters or whatever ?

[vinieme12 · Accepted solution]

You can restrict calculations for a given period using Set Analysis as below 

Sum({<DateField={">=$(=Date(Max(DateField)-90))<=$(=Date(Max(Date)))"}>}Sales)

Refer below blog for more 

https://community.qlik.com/t5/Qlik-Design-Blog/Dates-in-Set-Analysis/ba-p/1472511