Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
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
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
Here is a screenshot and a sample qvw application where you can see how it can be done: