HOW TO CREATE QUARTERS

[#1]

I need to create A BAR CHART with 4 bars each represention Q1,Q2,Q3,Q4 respectively.

so If I select <=Mar , then I will see only 1 bar 'Q1', if I select for example May, I wanna see Bar for 'Q1' and bar for 'Q2'  and so on.

I have Year and Month dimensions.  How can I do that

[sunny_talwar]

Would you be able to share a sample because without a sample, we are just beating around the bushes.

[#3]

I dont know how to add the attachment to the Reply so I created the new discussion

[sunny_talwar]

I see that new thread. I will work on getting a solution which might help

[#5]

Thanx Sunny

[maxgro]

.qvw is already attached

script with test data is

load

  *,

  'Q' & ceil((Month/3)) as Quarter;

load

  *,

  Year(Date) as Year,

  Month(Date) as Month;

load

  makedate(2015, ceil(rand()*12)) as Date,

  ceil(rand()*10) as Val

AutoGenerate 1000;

[#7]

Can you look at the actual QVW, QVD and Sample output . its under

"BAR CHART LINE ISSUE" thread