topic Re: bar chart - 2 bars in QlikView

bar chart - 2 bars

petermoyaert — Wed, 10 Feb 2016 12:15:12 GMT

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

avinashelite — Wed, 10 Feb 2016 12:22:35 GMT

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

Anonymous — Wed, 10 Feb 2016 12:48:11 GMT

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 — Thu, 11 Feb 2016 06:44:22 GMT

Hi Peter,

Did the solution work?

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