set analysis

[satishqlik]

Hello experts,

How to get next 5 years data, If I select 2010 in the year field

exp:Sum({<year={">2010<=2015"}>}sales)

By using set analysis how can we approach dynamically.?

I tried below exp like

Sum({<year={>$(=only(year))<=$(only(year)+5)}>}sales)

But it hasn't worked.

I would appreciate if anyone can help me out in this.

Thanks in adv!!

[Anonymous · Accepted solution]

Hi,

Try like this

sum({<year = {'>=$(=GetFieldSelections(year))<=$(=GetFieldSelections(year)+5)'} >}sales)

Regards,

Greeshma

[satishqlik]

Thanks for answering I'll try and get back to you!

[Agis-Kalogiannis]

Hi Satish

the reason why your expression does not work is because of some missing quotes.

Try the following:

Sum({<year={'>$(=only(year))<=$(only(year)+5)'}>}sales)

Also please note that year and sales are case sensitive.

Thanks

Agis

[Anonymous]

hi Satish, if your query is solved please close the thread by tagging it as correct answer. So that way someone can either learn from your question.

[prabhas277]

Hi satish,

please try this then it will come..

=sum({<year={">=$(=Min(year))<=$(=Min(year)+4)"}>}popu)

all fields are case sensitive check it properly

if it will helpful then give the correct answer

Regards,