Straight Table

[bhavvibudagam]

Hi, Please find the attached Qvw file.

I have a dimension "Year",In the Expression tab i have multiple Expressions.

When i click on 2005 it has to be display 2001 to 2005 years data

when i click on 2006 it has to be display 2002 to 2006 years data.the condition should be given in Calculated dimension only.

I have added sample file.Please help me to do.

Thanks

[sasiparupudi1]

=ValueLoop(Year-5,Year,1)

[bhavvibudagam]

Thanks for reply but not working

[Anonymous]

you can use your calculated Dimension, but you must define in Expression [<Year=>}

otherwise you will only get 1 year

alternatively you can try this Expression:

=Sum({<Year={'>=$(=max(Year-4))<=max(Year)'}>}[Claim Value])

[tresesco]

Bhavvi b wrote:

....the condition should be given in Calculated dimension only.

Why so? Do you have a specific reason for that? Why not in the expression itself?

[varshavig12]

Try this.

sum({<Year={"<=$(=max(Year)) >$(=AddYears(max(Year),-4))"} >} Sale_Amount)

[sasiparupudi1]

Check this attachement.. It needs Year Selection

[sasikanth]

HI,

You will always get only one value if you select in Listbox,

as an alternative you can get the same if you select the year through Slider

PFA

Thanks

sasi

[florentina_doga]

or use

sum({

    $

    <Year=e({<Year=({'$(=$(vEnd+1))'})>} Year)>

    }

     [Claim Value])

[bhavvibudagam]

Hi sasidhar,

If we select the year it is showing last five years.But it is showing error in calculated dimension without any selections and in all the years the value is same.In the previous file their is only 100 for all the years now i have updated the file with different values now you can find the issue.Please review the below file once.