Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
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