- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
bar chart - 2 bars
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.
Peter
- Tags:
- new_to_qlikview
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
add two expression one for the sales and one for the budget
or
if the sales and budget are stored as value in the column than add that column as the second dimension
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Peter,
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]
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Peter,
Did the solution work?
To close the thread, you have to mark a reply as answered