# App Development

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for
Did you mean:
Employee

## Calculate previous date (day before date)

Is there a way to calculate the day before a certain date ?

So if date='2017/07/28' the calculated date should be '2017/07/27'

1 Solution

Accepted Solutions
Partner - Specialist III

Hi Eric,

You can calculate using below set analysis:

Sum({<Date={'\$(Max(Date)-1)'}>}value)

In Text Object=Date(Max(Today()-1))

Thanks,

Arvind Patil

8 Replies
Specialist

Hi,

(Date - 1)??

Partner - Specialist III

Hi Eric,

You can calculate using below set analysis:

Sum({<Date={'\$(Max(Date)-1)'}>}value)

In Text Object=Date(Max(Today()-1))

Thanks,

Arvind Patil

Employee
Author

Thx,

Employee
Author

thx

Employee
Author

thx

Partner - Specialist III

Thanks,

Arvind Patil

Contributor III

What about if my previous date is not one day before? Could be 2 or 5 days... How can I calculate the day before no matter how many days in the past they are?

Regards!

Contributor

I´m having the same question. I want to show daily change in sales vs previous day for a whole month in a bar graph.

How can I accomplish this in Qlik Sense?