How to ignore selection

[d4rlie891]

Hi,

Anyone can help me, how to Ignore Year_Month Selection for this Set Analysis :

Max(Aggr(

sum({<YEAR_MONTH = {">=$(=date(addmonths(max({1}YEAR_MONTH), -12), 'YYYY-MM'))"} * {"<=$(=max({1}YEAR_MONTH))"}, JENIS_TRX>}TOT_TRANS),TANGGAL))

So if I do select the YEAR_MONTH, the Chart below will not change.

I also doesn't want this KPI changed by YEAR_MONTH Selection

FirstSortedValue(DISTINCT TANGGAL, -Aggr(sum(TOT_TRANS),TANGGAL))

Thanks for you help.

[arulsettu]

can you post sample qvf

[jonathandienst]

Put an override for YEAR_MONTH before the Aggr():

Max({<YEAR_MONTH>}

  Aggr(

  Sum({<

  YEAR_MONTH = {">=$(=date(addmonths(max({1}YEAR_MONTH), -12), 'YYYY-MM'))"}

  * {"<=$(=max({1}YEAR_MONTH))"}, JENIS_TRX>}TOT_TRANS)

  ,TANGGAL))

[jonathandienst · Accepted solution]

And

FirstSortedValue({<YEAR_MONTH>} DISTINCT TANGGAL, -Aggr(sum(TOT_TRANS),TANGGAL))

[d4rlie891]

Thanks So Much, It's Worked