Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
PGesterkamp
Contributor III
Contributor III

Trigger a period for the two previous months

Hello

On entering a sheet I would like it to be automaticly set for the period of  the two previous months as from today.  I have used:

 

(in the textfield search I wrote:)

=MONTH(TODAY())-1  (that works, but only for one month). How can I expand my range with 2 months?

11 Replies
BlondeThursday
Contributor III
Contributor III

This is brilliant for my application.

How would you alter it to select all of the previous six months before today?

BlondeThursday
Contributor III
Contributor III

Sorry, asked before looking at it properly.

 

='(' &(month(AddMonths(today(),-4)))&'|'&(month(AddMonths(today(),-3)))&'|'&(month(AddMonths(today(),-5)))&'|'&(month(AddMonths(today(),-2)))&'|'&(month(AddMonths(today(),-1)))& ')'