Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Current and previous months

Hi!

Trying to add action to select current and previous months in max year as a default, Month(Max([Date])) returns only the current month

Thanks

Kwame

3 Replies
Not applicable
Author

Kwame,

Fot the field WEEK I defined an action as ='<=$(=week(today()))'

This sets all the weeks.

For te field YEAR I defined an action as =year(today())

The combination of these two actions sets the YEAR and the WEEKS.

Regards,

Gerrit

Anonymous
Not applicable
Author

try you

Month(addmonth(Max(date),-1))

Anonymous
Not applicable
Author

Hi! Guys

The expressions are not giving the desired results.

=vMaxYear returns the current month ie. 2013 and now i would want all the months selected suppose the current month is July. So essentially when i open the document the 2013 and months Jan,Feb,Mar,April,May,June and July should all be selected

Thanks