Values that lies between two variables

[#1]

Hi,

Can you please help me to resolve this issue :

I have to list the years between a selected year Y and Y-1.

For example:

My selected Year is : 2013

The number of years on the past is : V_YearBack = 3

So i have to get : 2013 2012 2011 2010

Can any one help me ?

Thanks

[Clever_Anjos]

Something like

sum({<Year ={">=$(=MAX(Year)-$(V_YearBack ))"}*{"<=$(=MAX(Year))"}>} yourfield)

should solve your need

[#3]

Hi,

Thanks for your response but this doesn't resolve my problem.

I put : =sum({<Year ={">=$(=MAX(Year)-$(V_YearBack ))"}*{"<=$(=MAX(Year))"}>} Year)

and i got : Error on Dimension

Any other suggestion ?

[Josh_Good]

I have a few thoughts on how this could be done but it would depend on where you want the list to appear.  Could you please post a sample QVW showing where you need the list to appear.

[#5]

Hi ,

  Please use the code as below

=Sum({$<Year ={">=$(=(max(Year ))-$(V_YearBack)-1) <=(max(Year ))"}>} FieldName)

Regards

Yusuf

[#6]

Hi,

Please find attached my example.

What i want is : when i select for example 2013 and YearBach=3, i have to get on the table those years : 2013, 2012,2011

Can you help please ?

[#7]

Still the same error message

[#8]

Hi ,

can you please try now .

=Sum({$<Year ={">=$(=(max(Year ))-$(V_YearBack)) <=$(=(max(Year) ))"}>} Sales)

Also please find the attachment .

Regards

Yusuf

[#9]

Hi Yusuf,

I tested the solution that you sent me and i think this will resolve a part of my problem

Thank you so much for your help ... i will add this part of development on my application and i will let you know if it is ok.

Thanks

[#10]

Many Thinks it works