Qlik Community

Qlik Sense App Development

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

ehe
New Contributor III

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
Valued Contributor II

Re: Calculate previous date (day before date)

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

6 Replies
jmvilaplanap
Valued Contributor

Re: Calculate previous date (day before date)

Hi,

(Date - 1)??

arvind_patil
Valued Contributor II

Re: Calculate previous date (day before date)

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
New Contributor III

Re: Calculate previous date (day before date)

Thx,

ehe
New Contributor III

Re: Calculate previous date (day before date)

thx

ehe
New Contributor III

Re: Calculate previous date (day before date)

thx

arvind_patil
Valued Contributor II

Re: Calculate previous date (day before date)

Happy to Help You.

Thanks,

Arvind Patil