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: 
Not applicable

Set Analysis - Last 3 Months of Last Year

Here is my current syntax that is not working.

=sum({$<Year={$(=Max(Year)-1)}, MonthID = {">$(#=max(MonthID)-3) <=$(#=max(MonthID))"}> }Cnt)

What am I doing wrong?

10 Replies
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

This period based Set Analysis example Shared QlikView may be helpful to you:

http://community.qlik.com/qlikviews/1175

- Steve