Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor II

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
Highlighted

Re: bar chart - 2 bars

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

Partner
Partner

Re: bar chart - 2 bars

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]

Highlighted
Partner
Partner

Re: bar chart - 2 bars

Hi Peter,

Did the solution work?

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