topic Re: rolling year in QlikView

rolling year

Wed, 16 Sep 2015 12:04:05 GMT

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 — Wed, 16 Sep 2015 12:05:06 GMT

Have a look at this

MK_QSL — Wed, 16 Sep 2015 12:06:31 GMT

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

tresB — Wed, 16 Sep 2015 12:06:57 GMT

Try like:

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