viewing Q4 2010 and Q1 2011

[#1]

currently i have year/quarter/month/week list boxes, i also have line/bar charts with cyclic group year/quarter/month/week...

lets say the user wanna look data over Q4 2010 and Q1 2011, how can i go about doing it?

[#2]

Hi,

view QuarterName(date).

This function returns a display value showing the months of the quarter and year.

[#3]

how i do use this "view QuarterName(date)" exactly?

currently when i select Q4, Q1, 2011, 2010 from list boxes, i will be seeing Q4 and Q1 on the charts

however, the Q4 i see on the chart will be the result of Q4 of 2011 with Q4 of 2010 and the Q1 i see on the chart will be the result of Q1 of 2011 with Q1 of 2010...

how can i not see them aggregating the data together like that? instead, could i see this on the bar chart:

Bar-Of-Q4-2010   Bar-Of-Q1-2011

------------------------------------------------

      Q4 2010             Q1 2011

hope the description of my requirements is clearer now... thanks!

[#4]

hello guys, any idea how i could proceed?

[rahulgupta · Accepted solution]

Hey Hi Axon,

You have to create a new Additional Field in the Script,

Load   *,

          Quarter&' '&Year as QuarterYear

From table;

Then you can use it any where.

Hope this solves your issue.

Regards

[#6]

ahhhhh thanks Rahul! that did it

[rahulgupta]

my pleasure