How to show only 3 Quaters values as dimention

[grajmca_sgp123]

Hi All,

I have a Order Date field which will have values from 2014-01-01 to till date.

I have created Quarters  like Q1-14,Q2-14,Q3-14,Q4-14,Q1-15,Q2-15 ,Q2-15 and Q3-15.

But I want to show in bar chart dimension values only for  Q4-14,Q1-15,Q2-15 .

How we can show Q4-14,Q1-15,Q2-15 as dimensional values  ??????

Please provide your valuable suggestion.

Thanks in advance.

[sunny_talwar · Accepted solution]

You can use a calculated dimension like this:

If(Match(Quarters, 'Q1-14', 'Q1-15', 'Q2-15'), Quarters) and then remember to select Suppress When Null on the Dimensions tab of the properties.

HTH

Best,

Sunny

[MK_QSL]

Use Calculated Dimension

If(Match(Quarter,'Q1-14','Q1-15','Q2-15'), Quarter)

or

Aggr(If(Match(Quarter,'Q1-14','Q1-15','Q2-15'), Quarter),Quarter)

Don't forget to tick Suppress When Value is Null

[Anonymous]

in your Dimension you may define

if ([Order Date]>'30.09.2014' and [Order Date] < '01.07.2015', YourQuarterField)  - you Need to use your specific dateformat instead of 30.09.2014

better solution

Show a listbox with your quartes and select only your required quarters

[sunny_talwar]

Here is a screenshot and a sample qvw application where you can see how it can be done: