Qlik Community

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

Bar Chart - Budget and Actual as Grouped - Sliced by Quarter.jpg

Tags (2)
1 Solution

Accepted Solutions
whiteline
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
whiteline
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.