rolling year

[#1]

I want to display last two years data based on selection: I am using

concat({<OpYear={">=$(vTwoyear)<=$(vCurrentYear)"}>}  OpYear,'"|"')

But it gives me only 2014|2014|2014|2014 lot of times, Any solution for this?

[gautik92]

Have a look at this

Set Analysis for Rolling Periods

[MK_QSL]

concat(DISTINCT {<OpYear={">=$(vTwoyear)<=$(vCurrentYear)"}>}  OpYear,'"|"')

[tresesco]

Try like:

concat({<OpYear={">=$(vTwoyear)<=$(vCurrentYear)"}>} Distinct OpYear,'"|"')