Discussion Board for collaboration on QlikView Layout & Visualizations.
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)
Bar Chart - Budget and Actual as Grouped - Sliced by Quarter - Google Drawings
Go to Solution.
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:
And add the expression:
if(ValueList('Budget','Actual')='Actual', Sum (Actual), Sum (Budget))
Choose empty (space symbol) label for the ValueList('Budget','Actual') dimension.