Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

calculation of back date

how can i calculate the date 250 days behind today

for example today it is 12/12/2012 2 days behind this is 12/10/2012

1 Solution

Accepted Solutions
Highlighted
sreenivas
Contributor III

Re: calculation of back date

=Date(Num(Today())-250)

2 Replies
sujeetsingh
Honored Contributor III

Re: calculation of back date

Try like thi it will work on

sum({$<date={today-250}>,sales)

Highlighted
sreenivas
Contributor III

Re: calculation of back date

=Date(Num(Today())-250)

Community Browser