Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Creating a Stacked Bar Chart on two sets of expressions

Hello all,

I'm pretty new to Qlikview and have just started to play around on the bar charts.

I am currently creating a combo chart that shows the basics of Revenue, Cost and the margin. currently I have 2 bars 1. Revenue, 2. Cost and the margin is a line, but what I am trying to do with no luck is show a chosen month and the year to date figure on the same chart.

So I would have:

1) Stacked Revenue bar Month/Year to date.

2) Stacked Cost bar Month/Year to date.

Then I have 2 different lines for the margins

I have created 6 different expressions Revenue, Cost and Margin by both Month and Year, these are against a Project dimension.

Currently I can only manage to either group or stack all the expressions together, I sure this is something simple which I am just missing.

Kind Regards

Darren

3 Replies
alexandros17
Not applicable

Re: Creating a Stacked Bar Chart on two sets of expressions

Could you provide an example?

Not applicable

Re: Creating a Stacked Bar Chart on two sets of expressions

http://community.qlik.com/message/319922#319922 is this what you are looking at.?

Not applicable

Re: Creating a Stacked Bar Chart on two sets of expressions

Hi,

Just to provide a little more detail to this:

As an example:

Revenue MonthRevenue YtdCost MonthCost YtdMonth MarginYTD Margin
Project 1200120015082525.0031.25
Project 2600150055017008.33-13.33
Project 34003000215162546.2545.83

I have 3 projects these are set as my Dimension (Projects)

and currently I have 6 expressions one for each column:

1) Revenue Month

2) Revenue YTD

3) Cost Month

4) Cost YTD

5) Margin Month

6) Margin YTD

What I would like to see is:

Bar 1) Revenue Month & Revenue YTD (Two Different colours)

Bar 2) Cost Month & Cost YTD (Two Different colours)

Line 1) Margin Month (These are working fine)

Line 2) Margin YTD (These are working fine)

The bars need to be overlaided so the Revenue for Project one would read YTD 1200 (will be set to a high Transparency), then the Month would show inside as a solid colour)

I hope this makes sense

Thanks in advance

Darren