topic calculation of back date in QlikView https://community.qlik.com/t5/QlikView/calculation-of-back-date/m-p/428382#M489274 <HTML><HEAD></HEAD><BODY><P>how can i calculate the date 250 days behind today</P><P></P><P>for example today it is 12/12/2012 2 days behind this is 12/10/2012</P></BODY></HTML> Wed, 12 Dec 2012 05:05:53 GMT 2012-12-12T05:05:53Z calculation of back date https://community.qlik.com/t5/QlikView/calculation-of-back-date/m-p/428382#M489274 <HTML><HEAD></HEAD><BODY><P>how can i calculate the date 250 days behind today</P><P></P><P>for example today it is 12/12/2012 2 days behind this is 12/10/2012</P></BODY></HTML> Wed, 12 Dec 2012 05:05:53 GMT https://community.qlik.com/t5/QlikView/calculation-of-back-date/m-p/428382#M489274 2012-12-12T05:05:53Z Re: calculation of back date https://community.qlik.com/t5/QlikView/calculation-of-back-date/m-p/428383#M489275 <HTML><HEAD></HEAD><BODY><P>Try like thi it will work on</P><P></P><P>sum({$&lt;date={today-250}&gt;,sales)</P></BODY></HTML> Wed, 12 Dec 2012 05:09:25 GMT https://community.qlik.com/t5/QlikView/calculation-of-back-date/m-p/428383#M489275 sujeetsingh 2012-12-12T05:09:25Z Re: calculation of back date https://community.qlik.com/t5/QlikView/calculation-of-back-date/m-p/428384#M489276 <HTML><HEAD></HEAD><BODY><P>=Date(Num(Today())-250)</P></BODY></HTML> Wed, 12 Dec 2012 05:11:36 GMT https://community.qlik.com/t5/QlikView/calculation-of-back-date/m-p/428384#M489276 sreenivas 2012-12-12T05:11:36Z