topic Plot stacked bars and line in one graph in QlikView

Plot stacked bars and line in one graph

Wed, 21 Jul 2010 12:33:45 GMT

Hi, I need to plot 2 values on a graph.

First, I need to plot a stacked graph which has Y='spend', X='months' and the stacked categories='channel'. So the graph shows the total spend per month by media channel in a stacked bar chart.

Second, I need to add a line into the graph to show the 'sales' by 'month'. Spend will be on 1st axis (£1-10mil) and Sales will be on 2nd axis (£10-100mil).

Is there a way to do this? At the moment, I can only get grouped bars with a line in one graph, how do I get stacks and line in one graph? Thanks!!

Plot stacked bars and line in one graph

shumailh — Wed, 21 Jul 2010 13:27:59 GMT

You can get line and bar chart at the same time by combo chart option but as per my knowledge you cannot do stack in combo charts.

See the attachement.

Regards,
Shumail Hussain

Plot stacked bars and line in one graph

Wed, 21 Jul 2010 13:30:48 GMT

Use Combo Box chart type.

X='months' is a dimension.

Y='spend' - first expression as Bar.

'sales' by 'month' - second expression as line.

Plot stacked bars and line in one graph

Wed, 21 Jul 2010 14:08:56 GMT

thank you but I still cannot get the spend to display as a stacked bar marking the spend per 'channel', any ideas?

thanks!

Plot stacked bars and line in one graph

Wed, 21 Jul 2010 14:13:55 GMT

Add the 'channel' as second dimension.

Plot stacked bars and line in one graph

Wed, 21 Jul 2010 14:14:49 GMT

Add 'channel' as second dimension.

Plot stacked bars and line in one graph

shumailh — Wed, 21 Jul 2010 14:26:43 GMT

Antheayeung, see the attachement i have posted, i hope it will surve ur purpose

Plot stacked bars and line in one graph

Wed, 21 Jul 2010 14:37:29 GMT

I'm sorry, I'm using the personal edition so I can't open it.

Plot stacked bars and line in one graph

jonathandienst — Wed, 21 Jul 2010 16:21:18 GMT

You can use a combo chart type. It will stack the expressions that are bars and display the lines normally. Make sure that two or more expressions have only Bar checked under the Display Options in the Expressions tab and one or more expressions have only Line checked. Select Stacked on the Style tabbed.

I use this quite often on QV9

Regards
Jonathan

Plot stacked bars and line in one graph

nathanfurby — Thu, 22 Jul 2010 10:03:54 GMT

I think the issue here is that you cannot stack two dimensions and have a second expression (line in this case). Seems like a serious limitation - I have tried this in the past... and failed

Re: Plot stacked bars and line in one graph

Josh_Good — Wed, 14 Sep 2011 00:06:27 GMT

Here is a quick video that shows how to combine a stacked chart with a line chart.

Regards.

http://www.youtube.com/watch?v=-WIjMxAjRA4

Re: Plot stacked bars and line in one graph

Thu, 28 Feb 2013 18:15:05 GMT

looks like that link shoes you how to make a fantasy football team... is there an updated link?

Re: Plot stacked bars and line in one graph

Josh_Good — Thu, 28 Feb 2013 21:34:01 GMT

I have updated the link.