Rolling Month in Set analysis expression excluding Month Selection

[rsdhavle]

I have to calculate data for rolling 12 months in a variable and this variable value should not change based on field Month selection. Currently when i am selecting a Month in a field it is changing.

[robert_mika]

Try use Month= 

in your set analysis to ignore selection in the Month dimension.

like:

sum({<Month =,  }fieldname)

[sunny_talwar]

What is your expression right now?

[rsdhavle]

SUM({<Year=,MONTH=,YearMonth={'>$(=Max(YearMonth)-100) <=$(=Max(YearMonth))'}>}Revenue)

This is my current expression somehow even after exculding Month, it changes based on Month selection.

Is it because of YearMonth range i have defined in the expression

[sunny_talwar]

May be this:

Sum({<Year=, MONTH=, YearMonth = {'>$(=Max({<MONTH=>} YearMonth) - 100)<=$(=Max({<MONTH=>} YearMonth))'}>} Revenue)

[robert_mika]

Qlikview is case sensitive.

Is MONTH in set analysis = Month in Listboxes?