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: 
Not applicable

Plot stacked bars and line in one graph

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!!

12 Replies
shumailh
Creator III
Creator III

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

Not applicable
Author

Use Combo Box chart type.

X='months' is a dimension.

Y='spend' - first expression as Bar.

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

Not applicable
Author

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

thanks!

Not applicable
Author

Add the 'channel' as second dimension.

Not applicable
Author

Add 'channel' as second dimension.

shumailh
Creator III
Creator III

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

Not applicable
Author

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

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
nathanfurby
Specialist
Specialist

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 failedSad