Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ehe
Contributor III
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
Partner
Partner

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

6 Replies
jmvilaplanap
Specialist
Specialist

Hi,

(Date - 1)??

arvind_patil
Partner
Partner

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

ehe
Contributor III
Contributor III

Thx,

ehe
Contributor III
Contributor III

thx

ehe
Contributor III
Contributor III

thx

arvind_patil
Partner
Partner

Happy to Help You.

Thanks,

Arvind Patil