Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

10 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

Anonymous
Not applicable
Author

Thx,

Anonymous
Not applicable
Author

thx

Anonymous
Not applicable
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? 

Prithika
Contributor III
Contributor III

did you get any solution