Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! 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