https://community.qlik.com/t5/App-Development/Interval-Date-with-Set-Analysis/m-p/1993112#M82183 <P>Good Day, I created below interval expression and I would like to add set analysis on it.<BR /><BR />=Interval(Date(logged_date_key, 'YYYY/MM/DD') - Date(today(), 'YYYY/MM/DD'), 'DD')</P> <P>I want below set analysis filters on above expression<BR /><BR />{&lt;Case_Status={'Follow Up','Open','Work In Progress'}&gt;}</P> <P>Your assistance will be greatly appreciated</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 17 Oct 2022 06:39:36 GMT Mothapoe 2022-10-17T06:39:36Z https://community.qlik.com/t5/App-Development/Interval-Date-with-Set-Analysis/m-p/1993112#M82183 <P>Good Day, I created below interval expression and I would like to add set analysis on it.<BR /><BR />=Interval(Date(logged_date_key, 'YYYY/MM/DD') - Date(today(), 'YYYY/MM/DD'), 'DD')</P> <P>I want below set analysis filters on above expression<BR /><BR />{&lt;Case_Status={'Follow Up','Open','Work In Progress'}&gt;}</P> <P>Your assistance will be greatly appreciated</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 17 Oct 2022 06:39:36 GMT https://community.qlik.com/t5/App-Development/Interval-Date-with-Set-Analysis/m-p/1993112#M82183 Mothapoe 2022-10-17T06:39:36Z https://community.qlik.com/t5/App-Development/Interval-Date-with-Set-Analysis/m-p/1993202#M82194 <P>Try this</P> <P>=Interval(<STRONG>Avg</STRONG>({&lt;Case_Status={'Follow Up','Open','Work In Progress'}&gt;}Date(logged_date_key,'YYYY/MM/DD')-Date(today(),'YYYY/MM/DD')),'DD')</P> Mon, 17 Oct 2022 09:17:16 GMT https://community.qlik.com/t5/App-Development/Interval-Date-with-Set-Analysis/m-p/1993202#M82194 BrunPierre 2022-10-17T09:17:16Z