Discussion board where members can get started with QlikView.
I created a table in which I would like to visualize both sales and budget by means of a bar.
In the chart both sales and budget are shown as one bar per month. So cumulated.
I want per month both sales and budget in two different bars so that you can very easily see the variance against budget.
add two expression one for the sales and one for the budget
if the sales and budget are stored as value in the column than add that column as the second dimension
1. Set month as a dimension. [properties->dimension]
2. In the expression tab, sum(sales) as the first expression
The second expression as sum(budget)
3. Than set the style of the bar graph as stacked [properties->style]
Did the solution work?
To close the thread, you have to mark a reply as answered