QOQ bar chart with yearQuarter dimension

[#1]

hi,

I want to create bar chart with YearQuarter Dimension (eg. 2013_Q1,2014_Q1)

and only one expression using set analysis.

user may select year and Quarter selection (Eg. year=2012,2013,2014....)  (Eg. Q1,Q2,Q3,Q4)

similar result as below

[geert_gelade]

If I understand your question that a user selects years and quarters and you want a stacked barchart with values for the different companies, then you don't need set analysis in my opinion.

Just put "Quarter&'-'&Year" and "Company" as dimension and "sum(value)" as expression in the bar chart and add two list boxes for Year and Quarter.

[#3]

hi Geert

thanks for you reply,

when user select year =2014 and quarter= Q2 then stack bar chart should show

2 Stack bar in chart for "Q2 13" and "Q2 14"

[jagan]

Hi Vivek,

Try like this

sum({<quarter=>}value)

Regards,

Jagan.

[#5]

hi,

it's not working

[jagan]

Hi Vivek,

Try like this

sum({<quarteryear=, quarter=>}value)

What are the date fields you have?  What are the selections you made?

Regards,

Jagan.