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]

You can may be put a  condition

GetSelectedCount(Year)>0

in the enable Conditional  dialogue box?

[pho3nix90 · Accepted solution]

Is there any specific reason why this has to be done in dimension? This is not possible as far as I know to overwrite selections (IE set analysis) in dimensions, this will have to be done in expression.

Please see attached.

[bhavvibudagam]

Its working by making small change

=Count({<ACCIDENT_Year = {'>=$(=Max(ACCIDENT_Year)-4)<=$(=Max(ACCIDENT_Year))'}>}CASE_NUMBER)