# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted Not applicable

## Bar Chart - Budget and Actual as Grouped - Sliced by Quarter

Is this possible? (In my opinion it's not very useful since the budget amounts are stacked; not 0-based (except for Q1); i.e. hard to compare Q2 to Q2. But it's what the client wants)

• Two dimensions (Division ('North', 'South'), and Quarter ('Q1', 'Q2', 'Q3', 'Q4')
• First-level group the Division dimension
• Stack the quarter slices
• Two expressions (SUM(Budget), SUM(Actual));
• Second-level Group these two expressions

Bar Chart - Budget and Actual as Grouped - Sliced by Quarter - Google Drawings Tags (2)
1 Solution

Accepted Solutions
Honored Contributor II

## Re: Bar Chart - Budget and Actual as Grouped - Sliced by Quarter

Hi.

Yes it's possible. Assuming that you have Actual and Budget measures as different fields you can do the following.

Create a stacked bar chart with three dimensions:

Division

ValueList('Budget','Actual')

Quarter

And add the expression:

if(ValueList('Budget','Actual')='Actual', Sum (Actual), Sum (Budget))

Choose empty (space symbol) label  for the  ValueList('Budget','Actual') dimension.

1 Reply
Honored Contributor II

## Re: Bar Chart - Budget and Actual as Grouped - Sliced by Quarter

Hi.

Yes it's possible. Assuming that you have Actual and Budget measures as different fields you can do the following.

Create a stacked bar chart with three dimensions:

Division

ValueList('Budget','Actual')

Quarter

And add the expression:

if(ValueList('Budget','Actual')='Actual', Sum (Actual), Sum (Budget))

Choose empty (space symbol) label  for the  ValueList('Budget','Actual') dimension.