rangesum and ignore all selections

[ali_hijazi]

Hello

got a line chart with Dimension = Year

I have the following expression

If

  (

  Year=Max(Year) or QUARTER_YEAR = max(QUARTER_YEAR) or MonthYear=max(MonthYear),

  RangeSum(Above(total COUNT(DISTINCT{

  1

  <

  Year=$::Year

  ,MonthYear=$::MonthYear

  ,Month=$::Month

  ,QUARTER_YEAR=$::QUARTER_YEAR

  ,Quarter=$::Quarter

  ,RECORD_TYPE={'MAINSTREAM'}

  >

  } FIX_ID),0,RowNo(TOTAL)))

  )

everything is fine but isn't this expression supposed to ignore any selection made on hte fields except for year, month, and the ones mentioned above?

why when I select a field called Client I only see results below but I need the above chart to show as above

please advise as I see the years related to the selected client

[sunny_talwar · Accepted solution]

See if this helps:

If(Only({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>}Year)=Max({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>}Year)

or

Only({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>} QUARTER_YEAR) = Max({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>} QUARTER_YEAR)

or

Only({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>} MonthYear) = Max({1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>}MonthYear),

RangeSum(Above(total COUNT(DISTINCT{1<Year=$::Year, MonthYear=$::MonthYear, Month=$::Month, QUARTER_YEAR=$::QUARTER_YEAR, Quarter=$::Quarter, RECORD_TYPE={'MAINSTREAM'}>}FIX_ID),0,RowNo(TOTAL))))

[jonathandienst]

Are you using alternate states?

You don't have filter overrides in all places

Year=Max(Year) or QUARTER_YEAR = max(QUARTER_YEAR) or MonthYear=max(MonthYear),

should  be

Year=Max({1}Year) or QUARTER_YEAR = max((1)QUARTER_YEAR) or MonthYear=max({1}MonthYear),

or even

Year=Max({1<RECORD_TYPE={'MAINSTREAM'}>}Year)....

[ali_hijazi]

ah I wonder how I missed this

thank you

[sunny_talwar]

No problem

I am glad we were able to help.

Best,

Sunny