https://community.qlik.com/t5/App-Development/How-to-calculate-previous-date/m-p/1993251#M82199 <P>Hi,</P> <P>I have below expression for the current date column which is working fine, have to calculate previous date for another column.</P> <P>=sum(if(DT.Date = aggr(nodistinct max(DT.Date),measure),qty))</P> <P>I tried using below expression for previous date but it's not working , c<SPAN>an someone help me with the correct way?</SPAN></P> <P><SPAN>=sum(if(DT.Date = aggr(nodistinct date(max(DT.Date)-1,'MM/DD/YYYY'),measure),qty))</SPAN></P> Mon, 17 Oct 2022 10:54:25 GMT abc_18 2022-10-17T10:54:25Z https://community.qlik.com/t5/App-Development/How-to-calculate-previous-date/m-p/1993251#M82199 <P>Hi,</P> <P>I have below expression for the current date column which is working fine, have to calculate previous date for another column.</P> <P>=sum(if(DT.Date = aggr(nodistinct max(DT.Date),measure),qty))</P> <P>I tried using below expression for previous date but it's not working , c<SPAN>an someone help me with the correct way?</SPAN></P> <P><SPAN>=sum(if(DT.Date = aggr(nodistinct date(max(DT.Date)-1,'MM/DD/YYYY'),measure),qty))</SPAN></P> Mon, 17 Oct 2022 10:54:25 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-previous-date/m-p/1993251#M82199 abc_18 2022-10-17T10:54:25Z https://community.qlik.com/t5/App-Development/How-to-calculate-previous-date/m-p/1996395#M82505 <P>What do you get when you use your current formula for previous date?</P> Tue, 25 Oct 2022 06:26:38 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-previous-date/m-p/1996395#M82505 Andrew_Delaney 2022-10-25T06:26:38Z