SET expression how to add filter year > 2009 ?

[paulyeo11]

Hi All

sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, COMPETITOR = {'WAGO', 'iTDS'}>}distinct REVENUE_C)/1000000

Above expression from sunny , will plot the year from 2000 till YTD , may i know how to add filter to above expression , so that it will plot from year more then 2009 ?

Meaning i only want to see the chart 1 , X axis display from 2009 till 2015.

Paul

[paulyeo11]

My QV Doc

[sunny_talwar · Accepted solution]

May be this:

Sum({$<year = {">=2009"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, COMPETITOR = {'WAGO', 'iTDS'}>}distinct REVENUE_C)/1000000

[paulyeo11]

Hi sunny

Many thank

Paul