Year display

[ssriramin19]

Hi,

      I have a field called years. The field years contains the years from 2009 to 2013. I am using bar graph chart. My requirement is that the year 2011 should not displayedin the bar graph. It should be done only in the front end.

Can any one help me in resolving the above scenario.

Thanks

Sriram

[Anonymous]

Sriram,

You can use set analysis to eliminate a specific value.  If Year is a dimension of the chart, it will be a calculated dimension:
aggr(only({<Year-={2011}>} Year), Year)
Don't forget to check "suppress when value is null".

Regards,
Michael

[ssriramin19]

Can anyone help in resolving the above scenario. It is very urgent

Thanks for your time..

[sivarajs]

Try by generating calenadr adte using

Date(Ceil(Rand() * 1460) + Date('01/01/2009')) AS CalendarDate //1460 days from 01/01/2009 almost four years

Use year of calendar date as your dimension

[swuehl]

You can use a calculated dimension:

=if( years <> 2011, years)

[#6]

use the calculated dimension if ( Year='2011',Null(),Year) and check the Suppress when Value is null option.

[alexandros17]

if you use years as dimension you can write

if(years <> 2011, years, null())

and check the box hide null values

[narender123]

you can use query in script

eg.

load

a,b,c,Year

from ......

where Year>=2009 and <=2010 or Year>=2012 and <=2013;

I think this will help you.Try it.

Thanks.

[kji]

use "=if(years<>'2011',years,null())" as your dimension and enable Suppress when value is null for that dimension.

[#10]

Hi,

Write an if with 'different from 2011'.

By Rebeca