Skip to main content
Announcements
New: No-code data prep in Qlik Cloud Analytics™ TAKE A TOUR
cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Specialist
Specialist

Set expression with Addmonths

Hi experts

What's wrong with this formula?

Sum(
{<[Timestamp.autoCalendar.YearMonth]=
{"$(= addmonths(date(Max(Timestamp.autoCalendar.YearMonth), 'YYYY-MMM')), -1)"}>}
Sales
)

 

This formula is fine:

Sum(
{<
[Timestamp.autoCalendar.YearMonth]=
{"$(= date(Max(Timestamp.autoCalendar.YearMonth), 'YYYY-MMM'))"}>}
Sales)

Thanks for your help, Tom

1 Solution

Accepted Solutions
TomBond77
Specialist
Specialist
Author

got it: 

Sum(
{<
[Timestamp.autoCalendar.YearMonth]=
{"$(= date(addmonths(Max(Timestamp.autoCalendar.YearMonth), -1), 'YYYY-MMM'))"}>}
Sales
)

View solution in original post

1 Reply
TomBond77
Specialist
Specialist
Author

got it: 

Sum(
{<
[Timestamp.autoCalendar.YearMonth]=
{"$(= date(addmonths(Max(Timestamp.autoCalendar.YearMonth), -1), 'YYYY-MMM'))"}>}
Sales
)