Skip to main content
Announcements
Qlik Community Office Hours - Bring your Ideation questions- May 15th, 11 AM ET: REGISTER NOW
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