topic Re: Calculate previous date (day before date) in App Development

Calculate previous date (day before date)

Anonymous — Fri, 28 Jul 2017 09:52:22 GMT

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'

Re: Calculate previous date (day before date)

jmvilaplanap — Fri, 28 Jul 2017 10:21:19 GMT

Hi,

(Date - 1)??

Re: Calculate previous date (day before date)

arvind_patil — Fri, 28 Jul 2017 10:27:42 GMT

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

Re: Calculate previous date (day before date)

Anonymous — Fri, 28 Jul 2017 11:00:39 GMT

Thx,

Re: Calculate previous date (day before date)

Anonymous — Fri, 28 Jul 2017 11:00:51 GMT

thx

Re: Calculate previous date (day before date)

Anonymous — Fri, 28 Jul 2017 11:01:02 GMT

thx

Re: Calculate previous date (day before date)

arvind_patil — Fri, 28 Jul 2017 11:27:23 GMT

Happy to Help You.

Thanks,

Arvind Patil

Re: Calculate previous date (day before date)

JRamos — Wed, 20 Oct 2021 18:40:47 GMT

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!

Re: Calculate previous date (day before date)

Matute — Wed, 22 Dec 2021 19:44:40 GMT

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?

Re: Calculate previous date (day before date)

Prithika — Mon, 21 Aug 2023 09:28:21 GMT

did you get any solution

Re: Calculate previous date (day before date)

Prithika — Mon, 21 Aug 2023 09:28:41 GMT

did you got the solution?