Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
ehe
Employee
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
arvind_patil
Partner - Specialist III
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

View solution in original post

8 Replies
jmvilaplanap
Specialist
Specialist

Hi,

(Date - 1)??

arvind_patil
Partner - Specialist III
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

ehe
Employee
Employee
Author

Thx,

ehe
Employee
Employee
Author

thx

ehe
Employee
Employee
Author

thx

arvind_patil
Partner - Specialist III
Partner - Specialist III

Happy to Help You.

Thanks,

Arvind Patil

JRamos
Contributor III
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!

Matute
Contributor
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?