Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
petermoyaert
Contributor III
Contributor III

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

3 Replies
avinashelite

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

Anonymous
Not applicable

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]

Anonymous
Not applicable

Hi Peter,

Did the solution work?

To close the thread, you have to mark a reply as answered