topic Re: Calculation going back 30 days in straight table in QlikView https://community.qlik.com/t5/QlikView/Calculation-going-back-30-days-in-straight-table/m-p/1388666#M459372 <HTML><HEAD></HEAD><BODY><P>Are you making selection in Activity_Date field or another date and time related field? If you are making selection somewhere else, you might need to ignore selection in those field/s</P></BODY></HTML> Wed, 04 Oct 2017 01:11:52 GMT sunny_talwar 2017-10-04T01:11:52Z Calculation going back 30 days in straight table https://community.qlik.com/t5/QlikView/Calculation-going-back-30-days-in-straight-table/m-p/1388665#M459371 <HTML><HEAD></HEAD><BODY><P>I have a straight table,&nbsp; it doesn;t have a date dimension.</P><P></P><P>I'm trying in my expression calculation go back 30 days from the date selected in the dimension filter.</P><P></P><P>By doing this:</P><P></P><P>sum({&lt;Activity_Date = {"$(=Date(AddMonths(Only({$} Activity_Date), -1), 'MM/DD/YYYY'))"}&nbsp; &gt;} SENT_TO_CARRIER_COUNT_UNLAGGED)</P><P></P><P>What am I doing wrong.</P></BODY></HTML> Tue, 03 Oct 2017 22:37:34 GMT https://community.qlik.com/t5/QlikView/Calculation-going-back-30-days-in-straight-table/m-p/1388665#M459371 gerrycastellino 2017-10-03T22:37:34Z Re: Calculation going back 30 days in straight table https://community.qlik.com/t5/QlikView/Calculation-going-back-30-days-in-straight-table/m-p/1388666#M459372 <HTML><HEAD></HEAD><BODY><P>Are you making selection in Activity_Date field or another date and time related field? If you are making selection somewhere else, you might need to ignore selection in those field/s</P></BODY></HTML> Wed, 04 Oct 2017 01:11:52 GMT https://community.qlik.com/t5/QlikView/Calculation-going-back-30-days-in-straight-table/m-p/1388666#M459372 sunny_talwar 2017-10-04T01:11:52Z