Calculate previous date (day before date)

[Anonymous]

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'

[jmvilaplanap]

Hi,

(Date - 1)??

[arvind_patil · Accepted solution]

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]

Thx,

[Anonymous]

thx

[Anonymous]

thx

[arvind_patil]

Happy to Help You.

Thanks,

Arvind Patil

[JRamos]

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]

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]

did you get any solution