Chart Help

[nagarjuna_kotha]

Hi All,

I want to know small thing I have chart like below.

In dimension i have QuarterYear.In below chart I want to remove Q1 11, Q2 11, Q3 11, Q4 11.

How to remove only those .

[#2]

send that qvw file it would be better

[Anonymous]

depending of your dateformat you shoud use a calculated Dimension

dateformat

if (year(yourquarterfield) > 2011, yourquarterfield)

stringformat

if (right(yourquarterfield,2) <> '11,yourquarterfield)

[Anonymous]

First thing, its not clear what you want to remove, Q1 or 11??

If you want to remove 11 from Q1

then try:

mid(QuarterYear,1,2) as QuarterYear  // it wud give you Q1

[Gysbert_Wassenaar]

The easiest way is to select the other values. If you want to do that only to this chart and not other charts in your document you can modify your expressions to exclude these specific values. For example Sum(Sales) would become Sum({<QuarterYear -= {'Q1 11','Q2 11','Q3 11','Q4 11'}>}Sales).

[prma7799]

Hi Nagarjuna,

Copy..............

How to use English color....

[MarcoWedel]

Hi,

another solution could be:

=Sum({$<QuarterYear={"=Year(QuarterYear)>2011"}>} Value)

hope this helps

regards

Marco