Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
This period based Set Analysis example Shared QlikView may be helpful to you:
http://community.qlik.com/qlikviews/1175
- Steve