https://community.qlik.com/t5/QlikView/Calculating-a-year-previous-using-set-analysis-and-alternate/m-p/1890896#M1217281 <P>Good morning,</P> <P>&nbsp;</P> <P>I'm hoping that someone might be able to help me. I'm trying to build an expression to calculate an aggregation based on a year previous. So far I've got this but it doesn't work. The alternate states part is included due to another object we're planning (however it may be dropped!).</P> <P>=NUM(sum({$&lt;[ReportDate]= [State 1]::[ReportDate]-365,[Fees]={'EU','Home','RUK (Nursing)'},[Level]={'UG','PG Taught'},[SFC Funded]={'Yes'}&gt;}FTE),'0.0')</P> <P>ReportDate is our date field. In a text box I trialled the following code which worked:</P> <P>=date(ReportDate-365)</P> <P>I can't think of a way of adding this to the above set analysis in a was that will work. Does anyone have any ideas?</P> <P>Many thanks!</P> <P>Matt</P> Wed, 09 Feb 2022 10:46:49 GMT mattphillip 2022-02-09T10:46:49Z https://community.qlik.com/t5/QlikView/Calculating-a-year-previous-using-set-analysis-and-alternate/m-p/1890896#M1217281 <P>Good morning,</P> <P>&nbsp;</P> <P>I'm hoping that someone might be able to help me. I'm trying to build an expression to calculate an aggregation based on a year previous. So far I've got this but it doesn't work. The alternate states part is included due to another object we're planning (however it may be dropped!).</P> <P>=NUM(sum({$&lt;[ReportDate]= [State 1]::[ReportDate]-365,[Fees]={'EU','Home','RUK (Nursing)'},[Level]={'UG','PG Taught'},[SFC Funded]={'Yes'}&gt;}FTE),'0.0')</P> <P>ReportDate is our date field. In a text box I trialled the following code which worked:</P> <P>=date(ReportDate-365)</P> <P>I can't think of a way of adding this to the above set analysis in a was that will work. Does anyone have any ideas?</P> <P>Many thanks!</P> <P>Matt</P> Wed, 09 Feb 2022 10:46:49 GMT https://community.qlik.com/t5/QlikView/Calculating-a-year-previous-using-set-analysis-and-alternate/m-p/1890896#M1217281 mattphillip 2022-02-09T10:46:49Z